Re: How to list ALL PostgreSQL functions?

From: hubert depesz lubaczewski <depesz(at)depesz(dot)com>
To: Poul Kristensen <bcc5226(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: How to list ALL PostgreSQL functions?
Date: 2016-09-12 11:22:24
Message-ID: 20160912112224.r4343jfzxiznoqpi@depesz.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2016-09-12 11:56:54 Re: How to list ALL PostgreSQL functions?
Previous Message Poul Kristensen 2016-09-12 11:11:11 Re: How to list ALL PostgreSQL functions?