Re: pgadmin vs psql output

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Rakesh Kumar <rakeshkumar464(at)outlook(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: pgadmin vs psql output
Date: 2016-09-30 21:15:38
Message-ID: 15046.1475270138@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Rakesh Kumar <rakeshkumar464(at)outlook(dot)com> writes:
> I have a bytea col which stores Java UUID data. When I run
> Select cast(uuid_col as varchar) from table limit 1

> Output in pgadmin
> -===================
> "A0000000000000000000000000000001"

> Output in psql
> ========
> \x4130303030303030303030303030303030303030303030303030303030303031

> is there some setting in psql output I need to take care of.

See "bytea_output" parameter.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message David Rowley 2016-09-30 21:52:44 Re: Parallel query only when EXPLAIN ANALYZEd
Previous Message Tom Lane 2016-09-30 21:14:40 Re: System crashed: fatal error restarting postgres