Option required to dump bytea fields?

[Carlos]

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.

[Peter Eisentraut]

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.
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

[Carlos Oliva]

Thanks Peter. This is clarifying the problems that I was having with the
dump.

-----Original Message-----
From: Peter Eisentraut [mailto:pe*****@gmx.net]
Sent: Monday, May 10, 2004 11:20 AM
To: Carlos; 'p************@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.
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster