Обсуждение: psql \df option for procedures
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
>>>>> "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)
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
>
> 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
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:
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
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
Вложения
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