"Celia McInnis" <celia(at)drmath(dot)ca> writes:
> Is there some way to extract the text of a previously defined stored
> procedure from the database? (I just managed to clobber one of my files which
> contained a couple of my plpgsql functions in it.).
"pg_dump -s" is your best bet.
regards, tom lane