user511345
Reputation:
PostgreSQL table: How can I find a list of values that were inserted during a given time period?
Is there a Postgres function that would allow me to find which values were inserted during/after a giving time period, even if that given table/row does not have a timestamp value?
Upvotes: 3
Views: 94
Answers (1)
Magnus Hagander
Reputation: 25078
No. You can find the involved transaction ids by looking at the hidden system columns xmin and xmax, but you can't find the timestamp.
Upvotes: 1
Related Questions
- Postgresql - how to select the inserted row in the last 15min automatically
- How to find out when data was inserted to Postgres?
- Postgres: Count all INSERT queries executed in the past 1 minute
- how to get transactions on a database for a specific time
- PostgreSQL - Query to show which time intervals contain data
- Selecting timeranges based on insertion date of matched result
- Obtain insertion time of a tuple in an existing table in PostgreSQL 9.3
- Query rows by time of creation?
- PostgreSQL: how to fetch previous insert timestamp
- PostgreSQL insert query