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.