Thread: 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.