Postgres Pro
Downloads
Home   >   mailing lists

Re: How to list ALL PostgreSQL functions? - Mailing list pgsql-admin

From Poul Kristensen
Subject Re: How to list ALL PostgreSQL functions?
Date
Msg-id CAAOuvVpxhi3G+o65gi+BEaX3bYxQLZusQKx5S=WGMe2pD+9P+Q@mail.gmail.com
Whole thread Raw
In response to Re: How to list ALL PostgreSQL functions?  (hubert depesz lubaczewski <depesz@depesz.com>)
Responses Re: How to list ALL PostgreSQL functions?
List pgsql-admin
Tree view
Thanks a lot.for links :)

btw:

psql \df gives 

 
                       List of functions
 Schema | Name | Result data type | Argument data types | Type
--------+------+------------------+---------------------+------
(0 rows)

/Poul


2016-09-12 12:56 GMT+02:00 hubert depesz lubaczewski <depesz@depesz.com>:
On Mon, Sep 12, 2016 at 12:46:38PM +0200, Poul Kristensen wrote:
> Sorry for not clear speach!
>
> It seems that all functions have the prefix off  pg_.
>
> I want to list all functions maybe with a short description in the PG api
>
> E.g.
>
> some command listing
>
> pg_last_xlog_receive
> pg_current_xlog_location
> etc.
>
> the \df
> does not help in the case.

Check the docs.

psql \df shows you list of functions.

Description can be found in manual.

Start with:
https://www.postgresql.org/docs/current/static/bookindex.html#AEN182285

and then, click on appropriate function.

For example, link for pg_last_xlog_receive_location is
https://www.postgresql.org/docs/current/static/functions-admin.html#FUNCTIONS-RECOVERY-CONTROL

and pg_current_xlog_location is
https://www.postgresql.org/docs/current/static/functions-admin.html#FUNCTIONS-ADMIN-BACKUP

Best regards,

depesz




--
Med venlig hilsen / Best regards
Poul Kristensen
Linux-OS/Virtualizationexpert and Oracle DBA

pgsql-admin by date:

Previous
From: hubert depesz lubaczewski
Date:
Subject: Re: How to list ALL PostgreSQL functions?
Next
From: hubert depesz lubaczewski
Date:
Subject: Re: How to list ALL PostgreSQL functions?