On Fri, 2020-11-06 at 17:13 -0500, Tom Lane wrote: > Holger Jakobs <holger@xxxxxxxxxx> writes: > > > Of course pg_dump can also dump blobs, and it's even the default. You > > may use the option --no-blobs to leave them out. > > A glance at the man page can be more informative than just hearing > > something from someone. > > Especially information as out of date as that :-(. Glancing at the > commit log, the very first version of pg_dump (in PG 7.0) did not do > blobs, but that was fixed by 7.1. I have a vague recollection that > --no-blobs might've been the default for a while after that, but > certainly it's been well over a decade since it wasn't default. The exception is when except when --schema, --table, or --schema-only is specified. Then you have to use --blobs to get the large objects in the dump. Yours, Laurenz Albe -- Cybertec | https://www.cybertec-postgresql.com
