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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse sfpug by date

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