postgresqlsql-delete

Recover deleted rows in postgresql


After running a query like

 delete from table tablename

Can the records be recovered? From what I know Postgresql is just marking the records as deleted.


Solution

  • Try pg file dump.

    Source.

    EDIT: In the Postgres Wiki you can find the pg file dump git repository.