Re: listing triggers

Christopher Kings-Lynne wrote:

>> futhermore:
>> \dt lists tables
>> \ds lists sequences
>> \d tablename lists that table.
>> 
>> etc. etc.
>> 
>> But how can I get a listing of all used triggers on a certain table?
> 
> \d <tablename>
> 
> Chris
> 

Hi Chris,

Thanks for your response, but this is what I get:

column, Type, and Modifiers
+ 
Indexes and foreign key contraints.
No triggers.

The triggers are responsible for checking FK-contraints in other tables, 
that use the table I want to list as refering key.

This is what the help says:
\d [NAME]      describe table, index, sequence, or view\d{t|i|s|v|S} [PATTERN] (add "+" for more detail)
listtables/indexes/sequences/views/system tables
 

No triggers....

So, I am still in the dark.

Regards,
Erwin Moller