Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Recoved 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.

like image 723
Valentin Brasso Avatar asked Oct 10 '22 22:10

Valentin Brasso


1 Answers

Try pg file dump.

Source.

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

like image 123
Denis de Bernardy Avatar answered Nov 03 '22 19:11

Denis de Bernardy