JJN Tech Adventures
  • Projects
  • Forth
  • Blog
  • Blog Tags
  • Links
  • Categories
  • Search engines
  • About
  • |
  • 🇧🇷

PostgreSQL delete large objects

May 3, 2020 One-minute read
postgresql
-- delete all large objects
SELECT lo_unlink(l.oid) FROM pg_largeobject_metadata l;

REF: https://stackoverflow.com/questions/33138588/delete-all-large-objects-from-postgresql-database