psql \df option for procedures
Hackorum builds and tests every patch posted to the lists, not only commitfest submissions. This is Hackorum's own CI rather than the PostgreSQL project's, and it is still under testing - please report anything that looks wrong.
You can run a PostgreSQL built from this patch straight from Docker, with no checkout and no build:
docker run --rm -p 5432:5432 ghcr.io/hackorum-dev/postgres-patch:t38986psql -h localhost -U postgresBuilt from patchset v5 (message #5), July 27, 2026 at 08:07 PM.
Every patchset is also pushed to a branch of our PostgreSQL fork, so you can check out the same tree CI built. Without a PostgreSQL checkout:
git clone --branch t38986_5 https://github.com/hackorum-dev/postgres.gitIn a checkout you already have, add the fork once:
git remote add hackorum https://github.com/hackorum-dev/postgres.gitthen, for this patchset and every later one:
git fetch hackorum t38986_5 && git checkout t38986_5Patchset v5 (message #5) is on t38986_5
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
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
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