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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Tue, Oct 20, 2009 at 10:11 AM, Tena Sakai <tsakai@xxxxxxxxxxxxxx> 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.

-- 
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin


[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux