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