Обсуждение: table updated status

Поиск
Список
Период
Сортировка

table updated status

От
"finecur"
Дата:
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


Re: table updated status

От
Richard Huxton
Дата:
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