[prev in list] [next in list] [prev in thread] [next in thread]
List: postgresql-general
Subject: Re: [GENERAL] pgadmin vs psql output
From: Tom Lane <tgl () sss ! pgh ! pa ! us>
Date: 2016-09-30 21:15:38
Message-ID: 15046.1475270138 () sss ! pgh ! pa ! us
[Download RAW message or body]
Rakesh Kumar <rakeshkumar464@outlook.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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic