I'm using PostgreSQL 8.4 and I have a table that is cleared out and refilled with new data every so often. I want to be able to store the date that the table was last filled, but I'm not sure where to put it. I'm really a novice at database design, and the only two things I can think of are:
- Create a table with the sole purpose of storing the date
- Timestamp every row in the table with the same timestamp
There's about 1000 to 2000 rows normally. It's just for a hobby project. Any help will be greatly appreciated.