How to add metadata for every record in Azure postgres tables

Parag Kale 25 Reputation points
2025-06-10T14:08:12.63+00:00

Hi,

I have a situation in one of the applications I am working on where prior to going live in production, we are going to migrate data from legacy systems over the period of few weeks. And at the same time, there will be activity from users in this production application. i.e, new records generated and existing (migrated ) records updated from user activity.

I want to be able to identify what records have been migrated from legacy systems, what records are newly created by user activity in this application and what records were initially migrated but later on updated from user activity in this application.

I am exploring options to implement this . Any ideas are appreciated.

Thanks,

Azure Database for PostgreSQL
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.