CODEWITHSUNDEEP
sqlpostgresql
Rajesh Omanakuttan
Rajesh Omanakuttan

Reputation: 6918

Get the list of recently updated columns in PostgreSQL database

Using an SQL query, I would like to get the list of columns (corresponding to multiple tables) which are recently updated with INSERT/UPDATE (with in 10 minutes) on the PostgreSQL database!

I have tried using the option information_schema.columns but there is no information like updated_time for the columns.

Upvotes: 0

Views: 513

Answers (1)

Laurenz Albe
Laurenz Albe

Reputation: 246268

This sort of information is not available in PostgresSQL. You would have to collect it yourself using triggers on the tables, but that would incur a performance penalty.

Upvotes: 1

Related Questions