Alright, I've misunderstood this issue. Do you have to escape bytea columns during export or import? And how you would do this?
Ty 2011/5/24 Craig Ringer <cr...@postnewspapers.com.au> > On 24/05/11 14:30, jasmin.dizdare...@gmail.com wrote: > > We had trbls with our drupal site, because some settings are stored in > bytea columns. I think lobs are a problem too, but pls see the pg_dump docs > for details. > > Is it possible that you are referring to the `bytea_output' setting in > PostgreSQL 8.4 and above? > > If so, the issue isn't that pg_dump somehow fails to dump the bytea > data. Rather, it's that drupal doesn't deal well with bytea data from > newer versions of PostgreSQL until the bytea_output setting is changed > to 'escape' because it doesn't understand the new hex format. > > -- > Craig Ringer >
