Date: Mon, 12 Sep 2016 12:56:52 +0200
From: hubert depesz lubaczewski <depesz@depesz.com>
To: Poul Kristensen <bcc5226@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: How to list ALL PostgreSQL functions?
Message-ID: <20160912105651.43vut4eeaxk25rg3@depesz.com>
Reply-To: depesz@depesz.com
References: 
 <CAAOuvVqoDPW=jysJOjXZLc8yLsHSa=QDpnLLTqYMYiK+yE=QRg@mail.gmail.com>
 <38EB733C-FDF1-4644-ACC9-49D0CA125F79@simply.name>
 <CAAOuvVqJEEyGQS0iyoobRK5YVK9yTEi6xLMASjNBNLvBad2wZA@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Disposition: inline
In-Reply-To: 
 <CAAOuvVqJEEyGQS0iyoobRK5YVK9yTEi6xLMASjNBNLvBad2wZA@mail.gmail.com>
User-Agent: NeoMutt/ (1.7.0)
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

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


-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin