how to add new column in pg_class for object creation date dumping

Question

I want to create a column in pg_class for object creation dumping but I am not able to add. I am using below query: ALTER TABLE pg_catalog.pg_class ADD COLUMN relcreated TIMESTAMP;

when I run this query I'm getting below error: ERROR: permission denied: "pg_class" is a system catalog SQL state: 42501 Please suggest any way for object creation time dumping. This is quite important for me for auditing purpose.

score 1 · Answer 1 · answered May 21 '21 at 12:23

1

That's a system table. You can't just fiddle with them.

You might find event triggers useful though.

answered May 21 '21 at 12:23

Richard Huxton

21,516
3
39
51

score 0 · Answer 2 · answered May 21 '21 at 13:05

0

Set log_statement = 'ddl' and get the information from the log file.

You cannot change a catalog like that “ that would require non-trivial changes to the PostgreSQL code, and you'd lose the information during every upgrade.

answered May 21 '21 at 13:05

Laurenz Albe

209,280
17
206
263

I did this earlier but that's not working. I have created a user and checked. – Sadamh Hussain May 21 '21 at 13:17
It is working quite well. You must have made a mistake. – Laurenz Albe May 21 '21 at 13:36

how to add new column in pg_class for object creation date dumping

2 Answers2