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: web-2307463@davinci.ethosmedia.com (view raw or flat)
Thread:
Lists: sfpug
Pius,

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

Also:
\df
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.

-Josh

______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-2014 The PostgreSQL Global Development Group