Re: How to list ALL PostgreSQL functions?

[Poul Kristensen <bcc5226@xxxxxxxxx>]

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.

Thanks 

Poul

2016-09-12 12:31 GMT+02:00 Vladimir Borodin <root@xxxxxxxxxxx>:

12 сент. 2016 г., в 13:25, Poul Kristensen <bcc5226@xxxxxxxxx> написал(а):

Hi !

How do I get an overview of all functions in the PG api 

e.g. : 

posgres=# SELECT pg_last_xlog_receive_location();

postgres=# SELECT pg_current_xlog_location();

In my opinion it is not obvious how to list all pg_* functions.

Can anyone help?

\df pg_* in psql?

Thanks

Poul

--

May the force be with you…

https://simply.name

--

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