From: | wsheldah(at)lexmark(dot)com |
---|---|
To: | Justin Clift <justin(at)postgresql(dot)org> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: How can I view the definition of an existing trigger? |
Date: | 2001-08-13 13:18:44 |
Message-ID: | 200108131318.JAA05980@interlock2.lexmark.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(dot)org(at)interlock(dot)lexmark(dot)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(at)lexmark(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Ryan Mahoney | 2001-08-13 13:27:30 | Re: How can I view the definition of an existing trigger? |
Previous Message | Christopher Zach | 2001-08-13 12:15:12 | Re: Using oids for fast read-only access? |