Know the creation date of a column in a table

Question

I search to kwow created date of column field in table for my postgresql 11. I haven't found information in "information_schema.columns"

Regards

score 0 · Answer 1 · answered Dec 11 '21 at 06:01

Direct answer

Postgresql metadata does not contains creation or modification dates of DB objects.

So direct answer: it's impossible to find it from information_schema or from postgresql metadata objects.

Some limited possibilities exists to find this information from other sources.

Check:

SHOW log_statement;

if it's not none - then it's possible to search in postgresql log ALTER TABLE command.

If logs were not recycled then you're in luck.

It schould be possible to get some information exploring files of database. But requires knowledge of postgresql storage file layout.

If you don't have to filesystem and/or superuser rights - then no luck.