can I get a bit more attribute out of \dt directive?

From: "Tena Sakai" <tsakai(at)gallo(dot)ucsf(dot)edu>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: can I get a bit more attribute out of \dt directive?
Date: 2009-10-20 16:11:05
Message-ID: FE44E0D7EAD2ED4BB2165071DB8E328C04E84DA6@egcrc-ex01.egcrc.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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?

Thank you in advance.

Regards,

Tena Sakai
tsakai(at)gallo(dot)ucsf(dot)edu

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message k_b0000 2009-10-20 17:20:45 PostgreSQL 8.4.1 - ERROR: column "reltriggers" does not exist
Previous Message Tom Lane 2009-10-20 15:56:03 Re: WAL file compatibility