Обсуждение: Displaying kind of triggers on tables.

Поиск
Список
Период
Сортировка

Displaying kind of triggers on tables.

От
Rajesh Kumar Mallah
Дата:
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.