From: | Teodor Cimpoesu <teo(at)digiro(dot)net> |
---|---|
To: | |
Cc: | pgsql-general(at)postgreSQL(dot)org |
Subject: | Re: [GENERAL] How to display user-defined functions? |
Date: | 1999-09-01 00:00:05 |
Message-ID: | 37CC6C85.480B8685@digiro.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Mark Dalphin wrote:
>
> Hi,
>
> Is there a way to display user-defined functions? For example, if I define a
> function using PL/pgsql, what tables do I query and in what way to learn that
> the function exisits and further, what its defintion is? I can find functions
> that return known types, eg getTimeStamp, below, shows up with '\df', however
> functions defined returning type "opaque" do not show up, eq,
> "exon_foreign_keys", below.
afaik this *should* work:
SELECT * FROM pg_proc WHERE procname='your_f_name_here';
I'm not sure of "procname",though
also try to display system tables (I think \dS or something)
and peek into other suspicious pg_* tables :)
[snip]
--
CIMPOESU Teodor, Web Programmer (h)
@ DIGICOM S.A. Bucharest, Romania
@ Internet, site development
@ teo(at)digiro(dot)net, +(401)-330.47.28
official home page ~ http://www.digiro.net/
Internet web page ~ http://internet.digiro.net/
From | Date | Subject | |
---|---|---|---|
Next Message | Howie | 1999-09-01 04:49:47 | Re: [GENERAL] PostgreSQL table data structure generator... |
Previous Message | Chris Bitmead | 1999-08-31 23:58:41 | Re: [GENERAL] Prog to generate table structure ... |