Crystal,
You should be posting this on pgsql-novice. This mailing list is for
management of the PostgreSQL.org web sites.
> I was wondering if someone can steer me in the right direction. I'm
> trying to retrieve the text of the functions in our database. I've
> searched all over the internet and have not seen a way to do this. It
> seems that in pg_view there is a column called definition, but pg_proc
> has nothing this simple. I've tried looking at pg_dump to see if
> there's a way to use that, but haven't really seen one either. Any
> ideas or things I can try of a different direction I should be looking?
\df+ function_name
in psql
or pg_proc.prosrc
or see the NewSysViews project: www.pgfoundry.org/projects/newsysviews
--
--Josh
Josh Berkus
PostgreSQL @ Sun
San Francisco