view stored proc in postgres   (link)

ok, this isn't really a link, but it's a bit geeky and obscure for the front page

to view the source of a postgresql stored procedure from the command line:

select prosrc from pg_catalog.pg_proc where proname = 'procedure_name';