Обсуждение: track alter table history
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.
Thanks for the help,
Yi
This message and any attachments are intended only for the use of the addressee and may contain information that is privileged and confidential. If the reader of the message is not the intended recipient or an authorized representative of the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by e-mail and delete the message and any attachments from your system.
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