how to view stored procedures and triggers

is there a way to 'dump' the stored procedure and trigger so that i can use
it in another database?

Peter Choe

At 01:02 PM 1/6/2003, Darren Ferguson wrote:

--On Monday, January 06, 2003 15:16:23 -0500 Peter Choe
<choepete@mindspring.com> wrote:

is there a way to 'dump' the stored procedure and trigger so that i can
use it in another database?

pg_dump -s

It's in the schema of the table.

LER

Peter Choe

At 01:02 PM 1/6/2003, Darren Ferguson wrote:

\df will give list of stored procedures and i think if you add + \df+
will tell you about triggers also

HTH

On Mon, 6 Jan 2003, Peter Choe wrote:

i am not sure if i wrote a stored procedure and trigger for a
database. how can i see the stored procedure and trigger associated
to a database?

Peter Choe

---------------------------(end of
broadcast)--------------------------- TIP 1: subscribe and unsubscribe
commands go to majordomo@postgresql.org

--
Darren Ferguson

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 972-414-9812 E-Mail: ler@lerctr.org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749