Обсуждение: table updated status
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
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