From: Hilary Forbes <hforbes@dmr.co.uk>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Pgsql-sql@postgresql.org
Subject: Re: Where are user defined functions stored?
Date: Fri, 23 Sep 2005 17:18:22 +0100
Message-ID: <5.1.0.14.0.20050923171510.0205bc40@mailserver.dmr.co.uk> (raw)
In-Reply-To: <3796.1127486414@sss.pgh.pa.us>
References: <5.1.0.14.0.20050923150802.03484f38@mailserver.dmr.co.uk>
<5.1.0.14.0.20050923150802.03484f38@mailserver.dmr.co.uk>
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@dmr.co.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
**********************************************************
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-sql@postgresql.org
Cc: hforbes@dmr.co.uk, tgl@sss.pgh.pa.us
Subject: Re: Where are user defined functions stored?
In-Reply-To: <5.1.0.14.0.20050923171510.0205bc40@mailserver.dmr.co.uk>
* 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