pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedtrack 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