Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

Recoved deleted rows in postgresql

Tags:

postgresql

sql-delete

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
Sign in to Comment

Related questions

Downloading and using a database from an untrusted source?
JPA 2 (EclipseLink) Trying to use UUID as primary key EntityManager.find() always throws exception (Database is PostgreSQL)
Spring, Blob download, byte[] size increases twice
Is there anyway to export PostgreSQL schema condensed?
Login control in ASP.NET with PostgreSQL
Postgres optimize for insert/read only
:result-set-fn in clojure jdbc return error "The result set is closed." Why?
Getting strange googleapi Err 400 message connecting to postgresql CloudSQL instance
Get UML diagram from relational database [closed]
What's the proper index for querying structures in arrays in Postgres jsonb?
Postgresql delete multiple rows from multiple tables
Difference between set, \set and \pset in psql
PG::TRDeadlockDetected: ERROR: deadlock detected
How to create postgres extension inside the container?
Operational Error: FATAL: database "django" does not exist
Is INSERT RETURNING guaranteed to return things in the "right" order?
homebrew update irritating error message [closed]
How do I reference a unique index that uses a function in ON CONFLICT?
Psycopg2 Insert Into Table with Placeholders
CREATE UNIQUE INDEX IF NOT EXISTS in postgreSQL

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!