Do I need to use the –b option in pg_dump to dump
bytea fields? For a while now I have been routinely using the –b option
in pg_dump to back up, restore, and copy my databases because I thought that
this was necessary to dump bytea fields. I am not using other types of large
objects in my database. Recently, I tried to dump a database with this option and
the dump failed; however I can dump the database without the –b option
and my bytea fields seem to have been dumped properly as well as the rest of
the database. Thanks in advance for your response. |