Postgres Pro
Downloads
Home   >   mailing lists

Thread: how to view stored procedures and triggers

how to view stored procedures and triggers

From
Peter Choe
Date:
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

Re: how to view stored procedures and triggers

From
Peter Choe
Date:
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

Re: how to view stored procedures and triggers

From
Larry Rosenman
Date:

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