Christopher Kings-Lynne wrote:
>> Thanks for your response, but this is what I get:
>>
>> column, Type, and Modifiers
>> +
>> Indexes and foreign key contraints.
>> No triggers.
>
> It lists triggers. Trust me, I wrote it.
(Sorry for late response)
Hi Chris,
You wrote it?!?
Ok, in that case I
On Sunday 08 August 2004 05:05, Erwin Moller wrote:
> >> But how can I get a listing of all used triggers on a certain table?
> >
> > \d
> >
> Thanks for your response, but this is what I get:
>
> column, Type, and Modifiers
> +
> Indexes and foreign key contraints.
> No triggers.
>
> The triggers
Thanks for your response, but this is what I get:
column, Type, and Modifiers
+
Indexes and foreign key contraints.
No triggers.
It lists triggers. Trust me, I wrote it.
The triggers are responsible for checking FK-contraints in other tables,
that use the table I want to list as refering key.
OK
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
>
> Chris
>
Hi Chris,
Thanks for your response, but this is what I ge
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
Chris
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
Hi,
When using psql I can list the tables and sequences by typing:
\d
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?
Thanks for your time
Regards,
Erwin Moller
