Tagged Questions
0
votes
3answers
349 views
Export Postgres table on remote server to CSV file on local machine?
I have access to DB on remote server where I can do only select command,
So, I can execute:
COPY products TO '/tmp/products.csv' DELIMITER ',';
But on that server I don't have permission to ...
1
vote
1answer
125 views
PG_bulkload utility postgresql need help
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 ...
