Re: [GENERAL] encode(bytea_value, 'escape') in PostgreSQL 9.0

2010-12-13 Thread Jasen Betts
On 2010-12-06, Florian Weimer fwei...@bfk.de wrote: * Tom Lane: Florian Weimer fwei...@bfk.de writes: The old 'escape' encoding used by PostgreSQL 8.4 and prior was pretty helpful for getting human-readable strings in psql. It seems this functionality was removed in PostgreSQL 9.0. Was

Re: [GENERAL] encode(bytea_value, 'escape') in PostgreSQL 9.0

2010-12-06 Thread Florian Weimer
* Tom Lane: Florian Weimer fwei...@bfk.de writes: The old 'escape' encoding used by PostgreSQL 8.4 and prior was pretty helpful for getting human-readable strings in psql. It seems this functionality was removed in PostgreSQL 9.0. Was this an accident or a deliberate decision? Could we

Re: [GENERAL] encode(bytea_value, 'escape') in PostgreSQL 9.0

2010-12-06 Thread Tom Lane
Florian Weimer fwei...@bfk.de writes: Put differently, I think it's rather odd that in 9.0, both encode(bytea_value, 'escape') and encode(bytea_value, 'hex') output hexadecimal values. I don't believe that; encode produces text not bytea, so its result is not affected by this setting.

Re: [GENERAL] encode(bytea_value, 'escape') in PostgreSQL 9.0

2010-12-06 Thread Florian Weimer
* Tom Lane: Florian Weimer fwei...@bfk.de writes: Put differently, I think it's rather odd that in 9.0, both encode(bytea_value, 'escape') and encode(bytea_value, 'hex') output hexadecimal values. I don't believe that; encode produces text not bytea, so its result is not affected by this

[GENERAL] encode(bytea_value, 'escape') in PostgreSQL 9.0

2010-12-03 Thread Florian Weimer
The old 'escape' encoding used by PostgreSQL 8.4 and prior was pretty helpful for getting human-readable strings in psql. It seems this functionality was removed in PostgreSQL 9.0. Was this an accident or a deliberate decision? Could we get it back, please? -- Florian Weimer

Re: [GENERAL] encode(bytea_value, 'escape') in PostgreSQL 9.0

2010-12-03 Thread Tom Lane
Florian Weimer fwei...@bfk.de writes: The old 'escape' encoding used by PostgreSQL 8.4 and prior was pretty helpful for getting human-readable strings in psql. It seems this functionality was removed in PostgreSQL 9.0. Was this an accident or a deliberate decision? Could we get it back,