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 CAAOuvVqJEEyGQS0iyoobRK5YVK9yTEi6xLMASjNBNLvBad2wZA@mail.gmail.com
Whole thread Raw
In response to Re: How to list ALL PostgreSQL functions?  (Vladimir Borodin <root@simply.name>)
Responses Re: How to list ALL PostgreSQL functions?  (hubert depesz lubaczewski <depesz@depesz.com>)
List pgsql-admin
Tree view
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@simply.name>:

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


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…




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

pgsql-admin by date:

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