Re: How to list ALL PostgreSQL functions?

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(at)depesz(dot)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