How do I avoid accidentally deleting postgres table rows?

Asked Apr 23 '19 at 16:05

Active Apr 23 '19 at 16:05

Viewed 229 times

I am using Postgres. It seems very easy to accidentally delete all of a table's data.

For example, I tried to delete one table row and accidentally deleted the whole table contents. This is no problem; the table contained mock data. However, the tables that I create in the future will contain important data.

Example of very easy deletion:

polls_db=# DELETE from polls_choice;
DELETE 8

Is there an easy way in Postgres to restore table data, or to soft delete table data whereby the data can be easily restored?

asked Apr 23 '19 at 16:05

3

You can create a role on db server with NO permission to delete operations and assign that role to a user and use that user only to perform actions. – Chetan Apr 23 '19 at 16:11
Another thing that will help is not to run SQL statements by hand. – Laurenz Albe Apr 23 '19 at 16:46
3

Make it a habit to always run `begin;` before running any dml statements directly – Kaushik Nayak Apr 23 '19 at 16:58
Related: [How to rollback an update in PostgreSQL](https://stackoverflow.com/q/12880994/190597) – unutbu Apr 23 '19 at 17:09

How do I avoid accidentally deleting postgres table rows?

0 Answers0