Answers for "export postgres table data to csv"

SQL
0

run postgresql dump to csv

copy (SELECT * FROM persons) to 'C:tmppersons_client.csv' with csv
Posted by: Guest on August-06-2020
0

csv into data postgres

COPY table_name FROM 'C:UsersPublicDocumentsert.txt' DELIMITER ',' CSV
-- make sure to put the file in public folder in windows 
-- Or temp folder in linux/mac 
-- because it might ask for some permissions...
Posted by: Guest on July-27-2021

Code answers related to "export postgres table data to csv"

Code answers related to "SQL"

Browse Popular Code Answers by Language