Re: table updated status

finecur wrote:
> 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?

No. There's no automatic timestamping. You could add your own triggers
if you wanted though.

> 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?

You can use the standards-based information_schema views or the
pg-specific system catalogue for this. See the manuals for details.

You might find it useful to start psql with -E, that way \dt and the
like will show you what SQL they execute.

--
Richard Huxton
Archonet Ltd