Answers for "export postgres as csv"

SQL
1

postgresql export output table as a csv

COPY table_name TO 'file_name.csv' DELIMITER ',' CSV HEADER;
Posted by: Guest on February-07-2021
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 "SQL"

Browse Popular Code Answers by Language