Postgres Pro
Downloads
Home   >   mailing lists

Re: encode(bytea_value, 'escape') in PostgreSQL 9.0 - Mailing list pgsql-general

From Tom Lane
Subject Re: encode(bytea_value, 'escape') in PostgreSQL 9.0
Date
Msg-id 13765.1291442719@sss.pgh.pa.us
Whole thread Raw
In response to encode(bytea_value, 'escape') in PostgreSQL 9.0  (Florian Weimer <fweimer@bfk.de>)
Responses Re: encode(bytea_value, 'escape') in PostgreSQL 9.0  (Florian Weimer <fweimer@bfk.de>)
List pgsql-general
Tree view 
Florian Weimer <fweimer@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, please?

I think you're looking for "set bytea_output = escape".

            regards, tom lane

pgsql-general by date:

Previous
From: Miguel Vaz
Date:
Subject: Table design - postgresql solution
Next
From: Tom Lane
Date:
Subject: Re: PG84 and SELinux