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

Re: Question about Postgres stored procedure

From: "Josh Berkus" <josh(at)agliodbs(dot)com>
To: Aditya <aditya(at)grot(dot)org>, 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:23:21
Message-ID: (view raw, whole thread or download thread mbox)
Lists: sfpug

> > (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?

in PSQL will give you a list of functions.

Or you can use PGAccess to browse your functions, or EMS HiTechs DB
Manager, or even TOra, if you're used to that interface.


______AGLIO DATABASE SOLUTIONS___________________________
                                       Josh Berkus
  Complete information technology      josh(at)agliodbs(dot)com
   and data management solutions       (415) 565-7293
  for law firms, small businesses        fax 621-2533
    and non-profit organizations.      San Francisco

In response to

sfpug by date

Next:From: Josh BerkusDate: 2003-01-08 19:55:18
Subject: Re: Meeting Next Tuesday the 14th
Previous:From: AdityaDate: 2003-01-08 17:09:50
Subject: Re: Question about Postgres stored procedure

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