| Lists: | pgsql-www |
|---|
| From: | "Crystal Whittier" <Crystal(at)eiri(dot)usu(dot)edu> |
|---|---|
| To: | <pgsql-www(at)postgresql(dot)org> |
| Subject: | function definitions |
| Date: | 2007-02-15 17:57:53 |
| Message-ID: | 742F743C08133644AE7014138CFB73046B5F57@eiriserver.hsrc.usu.edu |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-www |
To anyone who can help me out,
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?
Thanks,
Crystal Whittier
| From: | Josh Berkus <josh(at)agliodbs(dot)com> |
|---|---|
| To: | pgsql-www(at)postgresql(dot)org |
| Cc: | "Crystal Whittier" <Crystal(at)eiri(dot)usu(dot)edu> |
| Subject: | Re: function definitions |
| Date: | 2007-02-15 20:46:12 |
| Message-ID: | 200702151246.13019.josh@agliodbs.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-www |
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