From: | Larry Rosenman <ler(at)lerctr(dot)org> |
---|---|
To: | Peter Choe <choepete(at)mindspring(dot)com>, 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:18:41 |
Message-ID: | 190490000.1041884321@lerlaptop.iadfw.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
--On Monday, January 06, 2003 15:16:23 -0500 Peter Choe
<choepete(at)mindspring(dot)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(at)postgresql(dot)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(at)postgresql(dot)org)
>
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 972-414-9812 E-Mail: ler(at)lerctr(dot)org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749
From | Date | Subject | |
---|---|---|---|
Next Message | Jason Hihn | 2003-01-06 20:22:17 | Re: [GENERAL] www.postgresql.org |
Previous Message | Peter Choe | 2003-01-06 20:16:23 | Re: how to view stored procedures and triggers |