A
A
Andrey Kovalchuk2017-04-14 15:58:32
PostgreSQL
Andrey Kovalchuk, 2017-04-14 15:58:32

How to automatically transfer records older than a certain value to the archive?

Good day, dear ones.
Tell me, how do they implement the automatic movement of records older than a certain time to the archive?
For clarity (although everything is obvious): there are 10 records. 9 of them were created yesterday, 1 the day before yesterday. Everything that timezone.now() - datetime_publish > 2 days is archived.
And yet, how is this archive implemented? Add. a field in the general table or a separate table?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
A
Andrey Burov, 2017-04-14
@BuriK666

Well, for example https://www.postgresql.org/docs/9.5/static/ddl-par...

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question