Option required to dump bytea fields?
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.
Carlos wrote:
Do I need to use the -b option in pg_dump to dump bytea fields?
No, that is for "large objects", which are completely unrelated to bytea
columns.
Thanks Peter. This is clarifying the problems that I was having with the
dump.
-----Original Message-----
From: Peter Eisentraut [mailto:peter_e@gmx.net]
Sent: Monday, May 10, 2004 11:20 AM
To: Carlos; 'pgsql-general@postgresql.org'
Subject: Re: [GENERAL] Option required to dump bytea fields?
Carlos wrote:
Do I need to use the -b option in pg_dump to dump bytea fields?
No, that is for "large objects", which are completely unrelated to bytea
columns.