Re: how to view stored procedures and triggers - Mailing list pgsql-general

From Peter Choe
Subject Re: how to view stored procedures and triggers
Date
Msg-id 5.0.0.25.0.20030106151557.03c737a0@pop.mindspring.com
Whole thread Raw
In response to how to view stored procedures and triggers  (Peter Choe <choepete@mindspring.com>)
Responses Re: how to view stored procedures and triggers
List pgsql-general
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:
>\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



pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: refcursor
Next
From: Larry Rosenman
Date:
Subject: Re: how to view stored procedures and triggers