Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

i am using COPY command to export the data to the out file with changes made to the data before export using option ST_asBinary() using command

COPY (
    SELECT st_asBinary(geom) FROM n_america
) TO '/install/shp_data/n_america_asbin_1_col.txt' 
WITH DELIMITER ',';

now i am facing problem with Restoring back to the other table with geometry column , which is now converted to binary while exporting

i have tried with COPY FROM as well as PG_BULKLOAD utility , but i did't got any solution to do this ,

any one please help

Regards Deepak M

share|improve this question

1 Answer 1

Your simple solution is to import into a separate table and then use another query to copy the data back, converting to proper format.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.