Postgres Pro
Downloads
Home   >   mailing lists

Re: How can I display the contents of a function? - Mailing list pgsql-general

From Thom Brown
Subject Re: How can I display the contents of a function?
Date
Msg-id bddc86150901190507m7a6a56f3q2b25ac00a7602c1e@mail.gmail.com
Whole thread Raw
In response to Re: How can I display the contents of a function?  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
Responses Re: How can I display the contents of a function?
List pgsql-general
Tree view
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.kretschmer@schollglas.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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

pgsql-general by date:

Previous
From: Igor Katson
Date:
Subject: Re: How can I display the contents of a function?
Next
From: Igor Katson
Date:
Subject: How can I look at a recursive table dependency tree?