Postgres Pro
Downloads
Home   >   mailing lists

Re: Function list similar to psql's \df+ w/o code? - Mailing list pgsql-admin

From Wells Oliver
Subject Re: Function list similar to psql's \df+ w/o code?
Date
Msg-id CAOC+FBWFuO6FZkEPQ-5tyQxqkGqkU7UoJg6ED_c_na7Y2qvX7w@mail.gmail.com
Whole thread Raw
In response to Re: Function list similar to psql's \df+ w/o code?  (Ron <ronljohnsonjr@gmail.com>)
List pgsql-admin
Tree view
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.




--

pgsql-admin by date:

Previous
From: Ron
Date:
Subject: Re: Function list similar to psql's \df+ w/o code?
Next
From: Samed YILDIRIM
Date:
Subject: Re: Select on Foreign table is not working