Displaying kind of triggers on tables.

From: Rajesh Kumar Mallah <mallah(at)trade-india(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Displaying kind of triggers on tables.
Date: 2003-07-01 06:12:07
Message-ID: 200307011142.07594.mallah@trade-india.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Browse pgsql-admin by date

  From Date Subject
Next Message shreedhar 2003-07-01 07:02:49 cannot read block 319 - Input/output Error
Previous Message Michiel Lange 2003-07-01 05:41:48 Re: big tables with lots-o-rows