psql \df option for procedures

Started by Peter Eisentrautalmost 8 years ago6 messageshackers
Jump to latest
#1Peter Eisentraut
peter_e@gmx.net

psql's \df command current has options a/n/t/w to show
aggregates/normal/trigger/window functions. Do we want to add something
for procedures?

--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

#2Andrew Gierth
andrew@tao11.riddles.org.uk
In reply to: Peter Eisentraut (#1)
Re: psql \df option for procedures

"Peter" == Peter Eisentraut <peter.eisentraut@2ndquadrant.com> writes:

Peter> psql's \df command current has options a/n/t/w to show
Peter> aggregates/normal/trigger/window functions. Do we want to add
Peter> something for procedures?

yes

--
Andrew (irc:RhodiumToad)

#3Fabrízio de Royes Mello
fabriziomello@gmail.com
In reply to: Peter Eisentraut (#1)
Re: psql \df option for procedures

On Mon, Jul 2, 2018 at 7:07 AM, Peter Eisentraut <
peter.eisentraut@2ndquadrant.com> wrote:

psql's \df command current has options a/n/t/w to show
aggregates/normal/trigger/window functions. Do we want to add something
for procedures?

+1. I can write a patch to save your time If you don't do it yet.

Regards,

--
Fabrízio de Royes Mello Timbira - http://www.timbira.com.br/
PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento

#4Isaac Morland
isaac.morland@gmail.com
In reply to: Fabrízio de Royes Mello (#3)
Re: psql \df option for procedures

While you're looking at \df, you might want to consider removing the
display of source code (we have \sf for that, and it takes up a lot of
space), and add a column to display access permissions (who can execute the
function).

On 2 July 2018 at 09:22, Fabrízio de Royes Mello <fabriziomello@gmail.com>
wrote:

Show quoted text

On Mon, Jul 2, 2018 at 7:07 AM, Peter Eisentraut <
peter.eisentraut@2ndquadrant.com> wrote:

psql's \df command current has options a/n/t/w to show
aggregates/normal/trigger/window functions. Do we want to add something
for procedures?

+1. I can write a patch to save your time If you don't do it yet.

Regards,

--
Fabrízio de Royes Mello Timbira - http://www.timbira.com.br/
PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento

#5Peter Eisentraut
peter_e@gmx.net
In reply to: Peter Eisentraut (#1)
Re: psql \df option for procedures

On 02.07.18 12:07, Peter Eisentraut wrote:

psql's \df command current has options a/n/t/w to show
aggregates/normal/trigger/window functions. Do we want to add something
for procedures?

Here is a patch.

The updated help string doesn't read particularly elegantly. Better ideas?

--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

Attachments:

0001-psql-Add-option-for-procedures-to-df.patchtext/plain; charset=UTF-8; name=0001-psql-Add-option-for-procedures-to-df.patch; x-mac-creator=0; x-mac-type=0Download+43-10
#6Peter Eisentraut
peter_e@gmx.net
In reply to: Peter Eisentraut (#5)
Re: psql \df option for procedures

On 14.07.18 12:20, Peter Eisentraut wrote:

On 02.07.18 12:07, Peter Eisentraut wrote:

psql's \df command current has options a/n/t/w to show
aggregates/normal/trigger/window functions. Do we want to add something
for procedures?

Here is a patch.

committed

--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services