Skip site navigation (1) Skip section navigation (2)

Re: Question about Postgres stored procedure

From: Aditya <aditya(at)grot(dot)org>
To: Pius Chan <chanpius(at)hotmail(dot)com>
Cc: sfpug(at)postgresql(dot)org
Subject: Re: Question about Postgres stored procedure
Date: 2003-01-08 17:09:50
Message-ID: 20030108170950.GA38529@mighty.grot.org (view raw or flat)
Thread:
Lists: sfpug
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

In response to

Responses

sfpug by date

Next:From: Josh BerkusDate: 2003-01-08 17:23:21
Subject: Re: Question about Postgres stored procedure
Previous:From: Pius ChanDate: 2003-01-08 16:54:58
Subject: Question about Postgres stored procedure

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group