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?
From: Scott Marlowe [mailto:scott(dot)marlowe(at)gmail(dot)com]
Sent: Tue 10/20/2009 12:24 PM
To: Tena Sakai
Subject: Re: [ADMIN] can I get a bit more attribute out of \dt directive?
On Tue, Oct 20, 2009 at 10:11 AM, Tena Sakai <tsakai(at)gallo(dot)ucsf(dot)edu> wrote:
> Hi everybody,
> Is there any quick way to list attributes of table?
> As I type at psql prompt:
> \dt+ foo.mytable*
> It gives me 5 columns (schema, name, type, owner, and
> description) of tables named mytable1, mytable2, etc.
> in the schema foo.
> What I want would be the last modification date of each
> table. How can I get this out of psql?
That information is not stored by the db really, so there's no way to get it.
In response to
pgsql-admin by date
|Next:||From: Scott Marlowe||Date: 2009-10-20 20:44:50|
|Subject: Re: can I get a bit more attribute out of \dt directive?|
|Previous:||From: Anj Adu||Date: 2009-10-20 20:29:01|
|Subject: Re: server process crash|