Re: How to list ALL PostgreSQL functions?

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

In response to

Responses

Browse pgsql-admin by date

  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?