pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedFunction list similar to psql's \df+ w/o code?
3+ messages / 2 participants
[nested] [flat]
* Function list similar to psql's \df+ w/o code?
@ 2023-01-11 18:06 Wells Oliver <wells.oliver@gmail.com>
2023-01-11 18:25 ` Re: Function list similar to psql's \df+ w/o code? Ron <ronljohnsonjr@gmail.com>
0 siblings, 1 reply; 3+ messages in thread
From: Wells Oliver @ 2023-01-11 18:06 UTC (permalink / raw)
To: pgsql-admin
Find myself wanting to view the output of psql's \df+ someschema.* without
the source code column, which makes it unreadable in the terminal. Is there
a quick query?
--
Wells Oliver
wells.oliver@gmail.com <wellsoliver@gmail.com>
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Function list similar to psql's \df+ w/o code?
2023-01-11 18:06 Function list similar to psql's \df+ w/o code? Wells Oliver <wells.oliver@gmail.com>
@ 2023-01-11 18:25 ` Ron <ronljohnsonjr@gmail.com>
2023-01-11 19:55 ` Re: Function list similar to psql's \df+ w/o code? Wells Oliver <wells.oliver@gmail.com>
0 siblings, 1 reply; 3+ messages in thread
From: Ron @ 2023-01-11 18:25 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
On 1/11/23 12:06, Wells Oliver wrote:
> Find myself wanting to view the output of psql's \df+ someschema.* without
> the source code column, which makes it unreadable in the terminal. Is
> there a quick query?
Run this to see how "\df+" is generated. Modify it for your needs:
psql <some_db> -Ec "\df+ someschema.*"
--
Born in Arizona, moved to Babylonia.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Function list similar to psql's \df+ w/o code?
2023-01-11 18:06 Function list similar to psql's \df+ w/o code? Wells Oliver <wells.oliver@gmail.com>
2023-01-11 18:25 ` Re: Function list similar to psql's \df+ w/o code? Ron <ronljohnsonjr@gmail.com>
@ 2023-01-11 19:55 ` Wells Oliver <wells.oliver@gmail.com>
0 siblings, 0 replies; 3+ messages in thread
From: Wells Oliver @ 2023-01-11 19:55 UTC (permalink / raw)
To: Ron <ronljohnsonjr@gmail.com>; +Cc: pgsql-admin@lists.postgresql.org
Ah, thanks! -E is great, didn't know about it.
On Wed, Jan 11, 2023 at 10:25 AM Ron <ronljohnsonjr@gmail.com> wrote:
> On 1/11/23 12:06, Wells Oliver wrote:
> > Find myself wanting to view the output of psql's \df+ someschema.*
> without
> > the source code column, which makes it unreadable in the terminal. Is
> > there a quick query?
>
> Run this to see how "\df+" is generated. Modify it for your needs:
> psql <some_db> -Ec "\df+ someschema.*"
>
> --
> Born in Arizona, moved to Babylonia.
>
>
>
--
Wells Oliver
wells.oliver@gmail.com <wellsoliver@gmail.com>
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2023-01-11 19:55 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2023-01-11 18:06 Function list similar to psql's \df+ w/o code? Wells Oliver <wells.oliver@gmail.com>
2023-01-11 18:25 ` Ron <ronljohnsonjr@gmail.com>
2023-01-11 19:55 ` Wells Oliver <wells.oliver@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox