Skip to content
Advertisement

How to delete unnecessary records from postgresql database table

I have a table that includes versions of my table.

For example entity id 1, I need 1,7,8 version numbers. 2,4,6 version numbers are not needed, so I can delete them. Actually I need last insert, update, delete transaction version numbers for an entity. The others will delete.

Can I remove all unnecessary update ids in this way?

Advertisement

Answer

If “last” is defined by the value of date, you can use this query to delete earlier versions:

Output (from SELECT * after DELETE) for your sample data:

Demo on dbfiddle

User contributions licensed under: CC BY-SA
2 People found this is helpful
Advertisement