pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed
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?
Date: Mon, 12 Sep 2016 12:56:52 +0200
Message-ID: <20160912105651.43vut4eeaxk25rg3@depesz.com> (raw)
In-Reply-To: <CAAOuvVqJEEyGQS0iyoobRK5YVK9yTEi6xLMASjNBNLvBad2wZA@mail.gmail.com>
References: <CAAOuvVqoDPW=jysJOjXZLc8yLsHSa=QDpnLLTqYMYiK+yE=QRg@mail.gmail.com>
	<38EB733C-FDF1-4644-ACC9-49D0CA125F79@simply.name>
	<CAAOuvVqJEEyGQS0iyoobRK5YVK9yTEi6xLMASjNBNLvBad2wZA@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>

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



view thread (9+ messages)  latest in thread

Message-ID: <20160912105651.43vut4eeaxk25rg3@depesz.com>
Permalink:  ../20160912105651.43vut4eeaxk25rg3@depesz.com/
Also on:    postgresql.org/message-id/20160912105651.43vut4eeaxk25rg3@depesz.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: depesz@depesz.com, bcc5226@gmail.com
  Subject: Re: How to list ALL PostgreSQL functions?
  In-Reply-To: <20160912105651.43vut4eeaxk25rg3@depesz.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox