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

Thom Brown a écrit :
> 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.
>

pgAdmin looks at the prosrc column of the pg_proc catalog. You can do
the same with this query:

  SELECT prosrc FROM pg_proc WHERE proname='your function name here';

Regards.


--
Guillaume.
 http://www.postgresqlfr.org
 http://dalibo.com