Re: How to list ALL PostgreSQL functions? - Mailing list pgsql-admin

From hubert depesz lubaczewski
Subject Re: How to list ALL PostgreSQL functions?
Date
Msg-id 20160912112224.r4343jfzxiznoqpi@depesz.com
Whole thread Raw
In response to Re: How to list ALL PostgreSQL functions?  (Poul Kristensen <bcc5226@gmail.com>)
Responses Re: How to list ALL PostgreSQL functions?
List pgsql-admin
On Mon, Sep 12, 2016 at 01:11:11PM +0200, Poul Kristensen wrote:
> Thanks a lot.for links :)
>
> btw:
>
> psql \df gives

\df gives you list of user functions. you can add more parameters, to
limit/extend the list.

like:

\df pg_*

will list all functions (including system one) that start with pg_

\dfS

will list all system functions

\df+ *xlog*

will list all functions (including system) that contain "xlog" in their
name, with some additional columns, which include "description" - one
line info about the function.

Best regards,

depesz



pgsql-admin by date:

Previous
From: Poul Kristensen
Date:
Subject: Re: How to list ALL PostgreSQL functions?
Next
From: Tom Lane
Date:
Subject: Re: How to list ALL PostgreSQL functions?