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 [EMAIL PROTECTED] Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461 ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
