From: | Hilary Forbes <hforbes(at)dmr(dot)co(dot)uk> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Pgsql-sql(at)postgresql(dot)org |
Subject: | Re: Where are user defined functions stored? |
Date: | 2005-09-23 16:18:22 |
Message-ID: | 5.1.0.14.0.20050923171510.0205bc40@mailserver.dmr.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Tom
Many thanks. Suppose I now want to know if there are any user defined functions set up in my database? I was rather hoping I could do something simple like
\df
to get a list of **user** defined functions rather as \dt gives me a list of my tables and not the complete list of all the system tables as well. Is there a way of achieving this?
Hilary
At 10:40 23/09/2005 -0400, you wrote:
>Hilary Forbes <hforbes(at)dmr(dot)co(dot)uk> writes:
>> How can I easily get to see the definition of a user defined function
>> please?
>
>Look in pg_proc.
>
> regards, tom lane
>
>---------------------------(end of broadcast)---------------------------
>TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
Hilary Forbes
The DMR Information and Technology Group (www.dmr.co.uk)
Direct tel 01689 889950 Fax 01689 860330
DMR is a UK registered trade mark of DMR Limited
**********************************************************
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2005-09-23 16:22:33 | Re: Where are user defined functions stored? |
Previous Message | Aldor | 2005-09-23 15:52:02 | Re: [ADMIN] COPY TO / COPY FROM |