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
pgsql-admin by date
|Next:||From: Tom Lane||Date: 2009-10-20 19:51:20|
|Subject: Re: server process crash |
|Previous:||From: k_b0000||Date: 2009-10-20 19:24:25|
|Subject: Re: PostgreSQL 8.4.1 - ERROR: column "reltriggers" does