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 [email protected] -----Original Message----- From: Scott Marlowe [mailto:[email protected]] Sent: Tue 10/20/2009 12:24 PM To: Tena Sakai Cc: [email protected] 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 <[email protected]> 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.
