Re: How can I view the definition of an existing trigger?
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
Use pg_dump to dump your schema as a text file
(/usr/local/pgsql/bin/pg_dump -s > my_schema.sql). This text file should
contain *all* of the data that creates the schema of your database,
including triggers and stored procedures. I think this should work ;)
-Ryan
At 09:18 AM 8/13/01 -0400, wsheldah@lexmark.com wrote:
Show quoted text
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 PMTo: "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 acommand 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
---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.251 / Virus Database: 124 - Release Date: 4/26/01
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:
Show quoted text
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 PMTo: "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?