Re: can I get a bit more attribute out of \dt directive? - Mailing list pgsql-admin

From Scott Marlowe
Subject Re: can I get a bit more attribute out of \dt directive?
Date
Msg-id dcc563d10910201224o6484638eid6a2c40529198b50@mail.gmail.com
Whole thread Raw
In response to can I get a bit more attribute out of \dt directive?  ("Tena Sakai" <tsakai@gallo.ucsf.edu>)
List pgsql-admin
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.

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: PostgreSQL 8.4.1 - ERROR: column "reltriggers" does not exist
Next
From: Tom Lane
Date:
Subject: Re: server process crash