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
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
