Postgres Pro
Downloads
Home   >   mailing lists

Thread: How to see Trigger statement on pgAdmin ?

How to see Trigger statement on pgAdmin ?

From
"Ezequias Rodrigues da Rocha"
Date:
Hi list,<br /><br />I would like to know how to see the trigger statement like:<br /><br />"CREATE TRIGGER MY_TR
..."<br/><br />I just can see the trigged functions, on pgadmin. So if someone have just arrived on my company can't
seehow the trigger was generated. <br /><br />Regards ...<br clear="all" /><br />-- <br />
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-<br
/>                                  Atenciosamente(Sincerely)<br />                        Ezequias Rodrigues da Rocha
<br/> =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-<br />A pior das democracias ainda é
melhordo que a melhor das ditaduras<br />The worst of democracies is still better than the better of dictatorships <br
/><ahref="http://ezequiasrocha.blogspot.com/">http://ezequiasrocha.blogspot.com/</a>

Re: How to see Trigger statement on pgAdmin ?

From
"Obe, Regina"
Date:
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@postgresql.org [mailto:pgadmin-support-owner@postgresql.org] On Behalf Of Ezequias Rodrigues da Rocha
Sent: Tuesday, September 12, 2006 7:52 AM
To: pgadmin-support@postgresql.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.