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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Florian Weimer <fweimer(at)bfk(dot)de>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: encode(bytea_value, 'escape') in PostgreSQL 9.0
Date: 2010-12-04 06:05:19
Message-ID: 13765.1291442719@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Florian Weimer <fweimer(at)bfk(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2010-12-04 06:11:14 Re: PG84 and SELinux
Previous Message Miguel Vaz 2010-12-04 00:20:43 Table design - postgresql solution