pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
track alter table history
2+ messages / 2 participants
[nested] [flat]

* track alter table history
@ 2006-04-19 17:07 Ma, Yi <Yi_Ma@adp.com>
  2006-04-21 03:37 ` Re: track alter table history Jim C. Nasby <jnasby@pervasive.com>
  0 siblings, 1 reply; 2+ messages in thread

From: Ma, Yi @ 2006-04-19 17:07 UTC (permalink / raw)
  To: pgsql-admin

 

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.

^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: track alter table history
  2006-04-19 17:07 track alter table history Ma, Yi <Yi_Ma@adp.com>
@ 2006-04-21 03:37 ` Jim C. Nasby <jnasby@pervasive.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Jim C. Nasby @ 2006-04-21 03:37 UTC (permalink / raw)
  To: Ma, Yi <Yi_Ma@adp.com>; +Cc: 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



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2006-04-21 03:37 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-04-19 17:07 track alter table history Ma, Yi <Yi_Ma@adp.com>
2006-04-21 03:37 ` Jim C. Nasby <jnasby@pervasive.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox