Postgres Pro
Downloads
Home   >   mailing lists

pgadmin vs psql output - Mailing list pgsql-general

From Rakesh Kumar
Subject pgadmin vs psql output
Date
Msg-id DM2PR05MB622A55E77A4B7F8BDA0A1258CC10@DM2PR05MB622.namprd05.prod.outlook.com
Whole thread Raw
Responses Re: pgadmin vs psql output  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view 
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.

pgsql-general by date:

Previous
From: Rakesh Kumar
Date:
Subject: Re: Multi tenancy : schema vs databases
Next
From: Tom Lane
Date:
Subject: Re: Parallel query only when EXPLAIN ANALYZEd