Re: How to list only my functions and their content?

From: Raymond O'Donnell <rod(at)iol(dot)ie>
To: Phoenix Kiula <phoenix(dot)kiula(at)gmail(dot)com>
Cc: PG-General Mailing List <pgsql-general(at)postgresql(dot)org>
Subject: Re: How to list only my functions and their content?
Date: 2008-11-19 10:05:04
Message-ID: 4923E4D0.6030606@iol.ie
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 19/11/2008 10:01, Phoenix Kiula wrote:
> I am in psql. I tried "\dd" but this lists pg_catalog and stuff like
> that. Long list that I don't need.

You can add a pattern to \df, so if your functions are in the public
schema then do:

\df public.*

HTH,

Ray.

------------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod(at)iol(dot)ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Andrus 2008-11-19 10:50:23 Re: Conversion of string to int using digits at beginning
Previous Message Pavel Stehule 2008-11-19 10:03:45 Re: How to list only my functions and their content?