Need help how to reproduce MySQL binary to PosgreSQL

From: Condor <condor(at)stz-bg(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Need help how to reproduce MySQL binary to PosgreSQL
Date: 2020-08-09 06:12:14
Message-ID: 6ba79f0a4d46b6298b14749369df538a@stz-bg.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general


Hello,

how I can reproduce MySQL binary to PosgreSQL and use follow
functionality in PG.

On mysql I have table with 3 fields:

CREATE TABLE table (
user_id int,
user_info binary(4),
user_data binary(16)
);

then I use them for example:

UPDATE table set user_info = CHAR(0, 2, 0, 0), user_data = CHAR(123, 1,
0, 2) WHERE user_id = 1;

select and insert them as:

SELECT HEX(user_info) AS user_info, HEX(user_data) AS user_data FROM
table;
INSERT INTO table (user_info, user_data) VALUES
(UNHEX(hexdata_commng_from_app), UNHEX(hexdata_commng_from_app));

I check PG does not have functions HEX and UNHEX. Some one can help a
little ?

Regards,
HS

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ashesh Vashi 2020-08-09 06:20:13 Re: Need help how to reproduce MySQL binary to PosgreSQL
Previous Message Tom Lane 2020-08-07 20:38:31 Re: privileges oddity