Обсуждение: Function list similar to psql's \df+ w/o code?

Поиск
Список
Период
Сортировка

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

От
Wells Oliver
Дата:
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?

--

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

От
Ron
Дата:
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.

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

От
Wells Oliver
Дата:
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.




--