CAJ CAJ wrote:
Thanks for the response. This'd be wonderful if I can get my process
right. My assumptions (probably incorrect) are that pgdump has to be
excuted twice on a database with blobs. Once to get the data and once
to get the blob (using the -b flag).
Why do you assume that? The pg_dump manual says:
-b
--blobs
Include large objects in the dump. This is the default behavior
except when --schema, --table, or --schema-only is specified, so the
-b switch is only useful to add large objects to selective dumps.
IOW, in most cases you will just get the large objects for free, and
don't even need to use this flag to get them. No need to run twice.
cheers
andrew
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
