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

Reply via email to