Hello.
We have a table that has a POINT
data type column.
When we use pt-archiver to export to a csv file, the data for the POINT
type column are a bunch of random gibberish text.
Also we can not use this file later to import it because it throws an error with these data.
Is it possible in pt-archiver to define the --columns
option and try to convert the column, with the HEX() function so that we can have a csv file without these gibberish data?
For example something like --columns id,HEX(coordinates)
Is there another way to export correctly geometric data types?
Thank you.