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

From: Wells Oliver <wells(dot)oliver(at)gmail(dot)com>
To: Ron <ronljohnsonjr(at)gmail(dot)com>
Cc: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: Function list similar to psql's \df+ w/o code?
Date: 2023-01-11 19:55:33
Message-ID: CAOC+FBWFuO6FZkEPQ-5tyQxqkGqkU7UoJg6ED_c_na7Y2qvX7w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Ah, thanks! -E is great, didn't know about it.

On Wed, Jan 11, 2023 at 10:25 AM Ron <ronljohnsonjr(at)gmail(dot)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(dot)oliver(at)gmail(dot)com <wellsoliver(at)gmail(dot)com>

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Samed YILDIRIM 2023-01-11 20:20:35 Re: Select on Foreign table is not working
Previous Message Ron 2023-01-11 18:25:24 Re: Function list similar to psql's \df+ w/o code?