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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
