From: | Poul Kristensen <bcc5226(at)gmail(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: How to list ALL PostgreSQL functions? |
Date: | 2016-09-12 10:46:38 |
Message-ID: | CAAOuvVqJEEyGQS0iyoobRK5YVK9yTEi6xLMASjNBNLvBad2wZA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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(at)simply(dot)name>:
>
> 12 сент. 2016 г., в 13:25, Poul Kristensen <bcc5226(at)gmail(dot)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…
> https://simply.name
>
>
--
Med venlig hilsen / Best regards
Poul Kristensen
Linux-OS/Virtualizationexpert and Oracle DBA
From | Date | Subject | |
---|---|---|---|
Next Message | hubert depesz lubaczewski | 2016-09-12 10:56:52 | Re: How to list ALL PostgreSQL functions? |
Previous Message | Vladimir Borodin | 2016-09-12 10:31:24 | Re: How to list ALL PostgreSQL functions? |