Thread: Function list similar to psql's \df+ w/o code?
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
wells.oliver@gmail.com
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.
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
wells.oliver@gmail.com