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 20:42:16
Message-ID: FE44E0D7EAD2ED4BB2165071DB8E328C04E84DAC@egcrc-ex01.egcrc.org (view raw or flat)
Thread:
Lists: pgsql-admin
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(at)gallo(dot)ucsf(dot)edu


-----Original Message-----
From: Scott Marlowe [mailto:scott(dot)marlowe(at)gmail(dot)com]
Sent: Tue 10/20/2009 12:24 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 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

Responses

pgsql-admin by date

Next:From: Scott MarloweDate: 2009-10-20 20:44:50
Subject: Re: can I get a bit more attribute out of \dt directive?
Previous:From: Anj AduDate: 2009-10-20 20:29:01
Subject: Re: server process crash

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