From: | "Thom Brown" <thombrown(at)gmail(dot)com> |
---|---|
To: | "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: How can I display the contents of a function? |
Date: | 2009-01-19 13:07:52 |
Message-ID: | bddc86150901190507m7a6a56f3q2b25ac00a7602c1e@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Thanks everyone! I looked around the user-defined functions section of the
documentation, but there wasn't any mention of this. I'm sure others would
find it useful if it were included, or at least referenced to.
Thom
2009/1/19 A. Kretschmer <andreas(dot)kretschmer(at)schollglas(dot)com>
> In response to Thom Brown :
> > I would like to see what's in a function. I can do this if I use pgAdmin
> III
> > just by clicking on the function, and it appears in the SQL pane
> opposite. But
> > how is this done? Is there a command like DESCRIBE FUNCTION
> logging.do_stuff;
> > ? And if possible, doing this without psql.
>
> All details about a function are stored in pg_proc. So you can do a
> select on this table to retrieve the source-code.
>
>
> Andreas
> --
> Andreas Kretschmer
> Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header)
> GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
From | Date | Subject | |
---|---|---|---|
Next Message | Igor Katson | 2009-01-19 13:08:01 | How can I look at a recursive table dependency tree? |
Previous Message | Igor Katson | 2009-01-19 13:05:38 | Re: How can I display the contents of a function? |