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@xxxxxxxxxx>:
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
Poul Kristensen
Linux-OS/Virtualizationexpert and Oracle DBA