Re: [HACKERS] SQL procedures - Mailing list pgsql-hackers

From Simon Riggs
Subject Re: [HACKERS] SQL procedures
Date
Msg-id CANP8+j+nyynsZ2Bm3N3ss-izHdM-cF-pZmqrNyUofEQ9i79z2Q@mail.gmail.com
Whole thread Raw
In response to Re: [HACKERS] SQL procedures  (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>)
List pgsql-hackers
On 2 December 2017 at 01:31, Peter Eisentraut
<peter.eisentraut@2ndquadrant.com> wrote:
> On 11/30/17 15:50, Thomas Munro wrote:
>> postgres=# \df
>>                        List of functions
>>  Schema | Name | Result data type | Argument data types | Type
>> --------+------+------------------+---------------------+------
>>  public | bar  | integer          | i integer           | func
>>  public | foo  |                  | i integer           | proc
>> (2 rows)
>>
>> Should this now be called a "List of routines"?
>
> Maybe, but I hesitate to go around and change all mentions of "function"
> like that.  That might just confuse people.

Agreed

\dfn shows functions only
so we might want to consider having
\df say "List of functions and procedures"
\dfn say "List of functions"

and a new option to list procedures only
\dfp say "List of procedures"

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


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: [HACKERS] Constraint exclusion for partitioned tables
Next
From: "Bossart, Nathan"
Date:
Subject: Re: [HACKERS] Additional logging for VACUUM and ANALYZE