Re: function definitions

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