Skip site navigation (1) Skip section navigation (2)

Re: can I get a bit more attribute out of \dt directive?

From: "Tena Sakai" <tsakai(at)gallo(dot)ucsf(dot)edu>
To: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
Cc: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: can I get a bit more attribute out of \dt directive?
Date: 2009-10-20 21:14:05
Message-ID: FE44E0D7EAD2ED4BB2165071DB8E328C04E84DAE@egcrc-ex01.egcrc.org (view raw or flat)
Thread:
Lists: pgsql-admin
Hi Scott,

> Do you mean when the table was modified
> (i.e. alter table add column) or when the
> data in the table was changed?

I mean the latter, the data change.

> If it's when the table was changed, the
> easiest way is to store that in the comment
> for the table whenever you alter it.

Great idea!  That's my ticket to solution.

Many thanks.  I appreciate it.

Regards,

Tena Sakai
tsakai(at)gallo(dot)ucsf(dot)edu 


-----Original Message-----
From: Scott Marlowe [mailto:scott(dot)marlowe(at)gmail(dot)com]
Sent: Tue 10/20/2009 1:44 PM
To: Tena Sakai
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: [ADMIN] can I get a bit more attribute out of \dt directive?
 
On Tue, Oct 20, 2009 at 2:42 PM, Tena Sakai <tsakai(at)gallo(dot)ucsf(dot)edu> wrote:
> Hi Scott,
>
> Thank you for your reply.
>
>> That information is not stored by the db really,
>> so there's no way to get it.
>
> I think then I would build another column for
> timestamp.  But in object-oriented lingo, this
> would be a class field, rather than instance
> field, and I don't want to timestamp every row
> of each table.  The timestamp is strictly to
> tell when it was last modified.
>
> Is there any good way to do this?

Do you mean when the table was modified (i.e. alter table add column)
or when the data in the table was changed?  If it's when the table was
changed, the easiest way is to store that in the comment for the table
whenever you alter it.  Otherwise, you'll want a trigger or something
to store the latest update time in the latest row updated.  There's
probably other ways too, but would involve a separate table to store
such things.

In response to

pgsql-admin by date

Next:From: Tom LaneDate: 2009-10-20 21:16:24
Subject: Re: server process crash
Previous:From: Scott MarloweDate: 2009-10-20 20:44:50
Subject: Re: can I get a bit more attribute out of \dt directive?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group