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?
Regards,
Tena Sakai
tsakai@gallo.ucsf.edu
-----Original Message-----
From: Scott Marlowe [mailto:scott.marlowe@gmail.com]
Sent: Tue 10/20/2009 12:24 PM
To: Tena Sakai
Cc: pgsql-admin@postgresql.org
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@gallo.ucsf.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.
