Re: How to list ALL PostgreSQL functions?
| От | Poul Kristensen |
|---|---|
| Тема | Re: How to list ALL PostgreSQL functions? |
| Дата | |
| Msg-id | CAAOuvVpxhi3G+o65gi+BEaX3bYxQLZusQKx5S=WGMe2pD+9P+Q@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: How to list ALL PostgreSQL functions? (hubert depesz lubaczewski <depesz@depesz.com>) |
| Ответы |
Re: How to list ALL PostgreSQL functions?
|
| Список | pgsql-admin |
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
Poul Kristensen
Linux-OS/Virtualizationexpert and Oracle DBA
В списке pgsql-admin по дате отправления: