Re: track alter table history
| От | Jim C. Nasby |
|---|---|
| Тема | Re: track alter table history |
| Дата | |
| Msg-id | 20060421033710.GU49405@pervasive.com обсуждение исходный текст |
| Ответ на | track alter table history ("Ma, Yi" <Yi_Ma@adp.com>) |
| Список | pgsql-admin |
Unfortunately, I don't think there is any way. It might not be a bad idea to add created and last_modified columns to track this information. On Wed, Apr 19, 2006 at 12:07:43PM -0500, Ma, Yi wrote: > > We're in the process of development between model updating and database > implementation, and > > It's been done by 2 different groups. I am wondering how I could find > out what's the last time > > The table structure has been updated (such as rename column name , add > new columns...) > > I looked the data dictionary tables/views in the pg_catalog , but can't > find any information like this. -- Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
В списке pgsql-admin по дате отправления: