Insert WKB to POINT column in PostgreSQL

281 Views Asked by At

Having a hard time working out what do I need to do to insert this export from MySQL:

INSERT INTO cities VALUES ('Nameoftheciy',0x0000000001010000005C21ACC6129C48407AFF1F274CA65EC0);

I tried wrapping the value in single quotes or extracting the data as POINT() but it also returns an errors in PostgreSQL.

What is the right approach here?

0

There are 0 best solutions below