Skip to content

Instantly share code, notes, and snippets.

@scaint

scaint/query.sql

Created November 3, 2016 11:45
Show Gist options
  • Save scaint/0073fe23f6774e33dfb232ce898041d8 to your computer and use it in GitHub Desktop.
Save scaint/0073fe23f6774e33dfb232ce898041d8 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
query.sql
DELETE FROM tbl WHERE ctid = ANY(array(SELECT ctid FROM tbl LIMIT 10000)) RETURNING *;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment