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.