Re: how to view stored procedures and triggers

From: Peter Choe <choepete(at)mindspring(dot)com>
To: Darren Ferguson <darren(at)thread(dot)crystalballinc(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: how to view stored procedures and triggers
Date: 2003-01-06 20:16:23
Message-ID: 5.0.0.25.0.20030106151557.03c737a0@pop.mindspring.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)postgresql(dot)org
> >
>
>--
>Darren Ferguson

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Larry Rosenman 2003-01-06 20:18:41 Re: how to view stored procedures and triggers
Previous Message Tom Lane 2003-01-06 20:09:10 Re: refcursor