Re: Question about Postgres stored procedure

there might be a nicer way, but querying the pg_proc table is what I usually
do:

select proname, prosrc from pg_proc where proowner <> 1;

shows you the function name and text source for all functions in a db that
aren't system functions...

Adi

On Wed, Jan 08, 2003 at 08:54:58AM -0800, Pius Chan wrote:
> Hi,
>
> My name is Pius Chan and I come from a heavy Oracle background. Recently I
> try to use Postgres to implement a system and have several questions:
>
> (1) Is there a way to tell what plplsql stored procedures/functions are in
> a Postgres database?
> (2) Is it possible to extract the content of the stored procedure from the
> database?
>
> Thanks a lot,
>
> Pius
>
>
>
>
>
> _________________________________________________________________
> Help STOP SPAM: Try the new MSN 8 and get 2 months FREE*
> http://join.msn.com/?page=features/junkmail
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html