Re: How can I view the definition of an existing trigger?

Wes,

Is this the kind of "trigger text" data you were interested in?

select relname as table_name,
       tgname  as trigger_name,
       tgtype  as trigger_type,
       proname as trigger_function
from   pg_class, pg_trigger, pg_proc
where  pg_class.oid = tgrelid
and    tgfoid = pg_proc.oid
and    tgisconstraint = 'f'
order by table_name, trigger_name;

Bernie

wsheldah@lexmark.com wrote:

>
>Thanks for the reply.  I checked pg_trigger, but it only seems to have
>information *about* the trigger, and not the actual text of the trigger command.
>As far as I can tell, the only way for me to hang on to trigger definitions is
>to put the create trigger commands in a file that I then source into psql.  As
>for triggers already created, my best bet may be to drop what's there and
>recreate it so I know exactly what it does.  Unless anyone has a better idea....
>
>
>
>
>Justin Clift <justin%postgresql.org@interlock.lexmark.com> on 08/11/2001
>04:59:52 PM
>
>To:   "Wesley_Sheldahl/Lex/Lexmark.LEXMARK"@sweeper.lex.lexmark.com
>cc:    (bcc: Wesley Sheldahl/Lex/Lexmark)
>Subject:  Re: [GENERAL] How can I view the definition of an existing trigger?
>
>
>Hi Wes,
>
>Not sure exactly, but in theory it would be stored in one of
>PostgreSQL's special pg_* tables.  So, also in theory, if you can
>isolate where they're stored, you might be able to find it.
>
>:-)
>
>Regards and best wishes,
>
>Justin Clift
>
>
>wsheldah@lexmark.com wrote:
>
>>Is there any way short of a full database dump to view the "CREATE TRIGGER"
>>statement of a trigger after it's been created, preferable via a command line
>>tool like psql?  Is it accessible via any of the GUI tools out there?  Thanks,
>>
>>Wes
>>
>>---------------------------(end of broadcast)---------------------------
>>TIP 4: Don't 'kill -9' the postmaster
>>
>
>--
>"My grandfather once told me that there are two kinds of people: those
>who work and those who take the credit. He told me to try to be in the
>first group; there was less competition there."
>   - Indira Gandhi
>
>
>
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 5: Have you checked our extensive FAQ?
>
>http://www.postgresql.org/users-lounge/docs/faq.html
>