Displaying kind of triggers on tables. - Mailing list pgsql-admin

From Rajesh Kumar Mallah
Subject Displaying kind of triggers on tables.
Date
Msg-id 200307011142.07594.mallah@trade-india.com
Whole thread Raw
List pgsql-admin
Hi,

It would be nice if \d command displayes the
trigger details . Currently we use
pg_dump -s -t table_name  to get the details.

For many users the communication between server
and client is not ver fast so pg_dump takes ages
other option is to login to the remote db server
and excute pg_dump local that is what i do anyway.

Details means name of procedure getting executed +
when , [ before|after]  [update | insert ]

if this feature is worth shall i try writing a patch ;-)

regds
Mallah.

--
Rajesh Kumar Mallah,
Project Manager (Development)
Infocom Network Limited, New Delhi
phone: +91(11)6152172 (221) (L) ,9811255597 (M)

Visit http://www.trade-india.com ,
India's Leading B2B eMarketplace.

pgsql-admin by date:

Previous
From: Michiel Lange
Date:
Subject: Re: big tables with lots-o-rows
Next
From: "shreedhar"
Date:
Subject: cannot read block 319 - Input/output Error