Thread: pgadmin vs psql output
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.
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