| From: | Luca Ferrari <fluca1978(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | get last timestamp of table ddl |
| Date: | 2021-11-24 13:53:24 |
| Message-ID: | CAKoxK+5uz67DxYcF=6ese6imi7ovHoqwjB+YE4X46sNv_9KN0w@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi all,
I think I already know the answer, however I came across this table in
Oracle <https://docs.oracle.com/cd/B19306_01/server.102/b14237/statviews_2005.htm#i1583352>
that has two columns that triggered my attention: CREATED and
LAST_DDL_TIME.
Apart from being dates (in the Oracle way), they store the time of
creation and last modification to the table structure.
I don't have any particular use case except from blaming someone about
a change in the database structure, however I'm curious: is there a
smarter way to achieve this in PostgreSQL than simply relying on logs
and commit timestamps?
Luca
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Shaozhong SHI | 2021-11-24 13:57:06 | How to set alias data type? |
| Previous Message | Tom Lane | 2021-11-24 02:24:28 | Re: Max connections reached without max connections reached |