table updated status

From: "finecur" <finecur(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: table updated status
Date: 2007-02-02 23:48:48
Message-ID: 1170460128.674182.322180@m58g2000cwm.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

Can I list tables and the time they were last update (adding columns,
drop columns) using sql, something like the "ls -l" command under
unix?

Can I compare the table definitions (tables, fields, but not data) of
two database using sql, something like the "diff file1, file2" command
under unix?

Thanks,

f

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Harpreet Dhaliwal 2007-02-03 08:26:29 some ports closed in Fedora
Previous Message Joshua D. Drake 2007-02-02 23:14:36 Re: Re: [pgsql-patches] [GENERAL] Corrupt database? 8.1/FreeBSD6.0