Re: How to see Trigger statement on pgAdmin ?

From: "Obe, Regina" <robe(dot)dnd(at)cityofboston(dot)gov>
To: "Ezequias Rodrigues da Rocha" <ezequias(dot)rocha(at)gmail(dot)com>, <pgadmin-support(at)postgresql(dot)org>
Subject: Re: How to see Trigger statement on pgAdmin ?
Date: 2006-09-12 12:59:53
Message-ID: 53F9CF533E1AA14EA1F8C5C08ABC08D2DAAD5E@ZDND.DND.boston.cob
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

On 1.4 and above, if you expand the table with the trigger on it, you will see a grouping called "Triggers" that lists all the triggers on that table and shows you the

CREATE TRIGGER ...
statement.

________________________________

From: pgadmin-support-owner(at)postgresql(dot)org [mailto:pgadmin-support-owner(at)postgresql(dot)org] On Behalf Of Ezequias Rodrigues da Rocha
Sent: Tuesday, September 12, 2006 7:52 AM
To: pgadmin-support(at)postgresql(dot)org
Subject: [pgadmin-support] How to see Trigger statement on pgAdmin ?

Hi list,

I would like to know how to see the trigger statement like:

"CREATE TRIGGER MY_TR ..."

I just can see the trigged functions, on pgadmin. So if someone have just arrived on my company can't see how the trigger was generated.

Regards ...

--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Atenciosamente (Sincerely)
Ezequias Rodrigues da Rocha
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
A pior das democracias ainda é melhor do que a melhor das ditaduras
The worst of democracies is still better than the better of dictatorships
http://ezequiasrocha.blogspot.com/

-----------------------------------------
The substance of this message, including any attachments, may be
confidential, legally
privileged and/or exempt from disclosure pursuant to Massachusetts
law. It is intended
solely for the addressee. If you received this in error, please
contact the sender and
delete the material from any computer.

Browse pgadmin-support by date

  From Date Subject
Next Message Ezequias Rodrigues da Rocha 2006-09-13 12:49:15 Error on start PgAdmin (didn't find pgpass.conf)
Previous Message Ezequias Rodrigues da Rocha 2006-09-12 11:52:26 How to see Trigger statement on pgAdmin ?