postgresql + navicat想更新表a的某一行数据，结果忘加where条件了。结果就是全部行都被update成了相同数据
这样还有救么？有撤销这次操作的方法吗？？
晕死了。。
走同样的路，发现不同的人生
The default log path is generally in /var/lib/pgsql/9.5/data/pg_log, and the default log level is ddl. Please find it quickly.
Learn your lesson.
The database prohibits destructive operations such as DELETE and UPDATE, and uses CREATE, INSERT, RENAME, version control, etc. instead.
Yes, pgsql should have the ability to write statement logs, just roll back. If mysql has it, pgsql should also have it
Unless you have a backup. .
Log recovery. Log recovery. Log recovery. Log recovery. Log recovery. Log recovery.
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
The default log path is generally in /var/lib/pgsql/9.5/data/pg_log, and the default log level is ddl. Please find it quickly.
Learn your lesson.
The database prohibits destructive operations such as DELETE and UPDATE, and uses CREATE, INSERT, RENAME, version control, etc. instead.
Yes, pgsql should have the ability to write statement logs, just roll back. If mysql has it, pgsql should also have it
Unless you have a backup. .
Log recovery. Log recovery. Log recovery. Log recovery. Log recovery. Log recovery.