PostgreSQL exported csv file could not be read in ms Sql Server database

Question

A csv file was exported from PostgreSQL database, but the exported file could not be imported into SQL Server, but same csv was easily imported into PostgreSQL.

Query to export was:

copy(select * from tablename where columnname = 'z') to '/path'

That does not produce a csv file. It is producing what PostgreSQL calls a text formatted file. — jjanes
– jjanes, Commented Aug 27, 2020 at 15:36

Garett · Accepted Answer · 2020-08-28 21:35:44Z

2

As mentioned in the comments, that statement does not create a CSV file. The correct syntax is:

copy(select * from tablename where columnname = 'z') to '/path/file_name.csv' delimiter ',' csv header;

A brief description of the options is below. See the documentation for more details.

DELIMITER - indicates the character separator to use. Default is tab for CSV
CSV - indicates CSV format
HEADER - the file should contain the header line with the column names

edited Aug 28, 2020 at 21:35

user330315

answered Aug 28, 2020 at 20:14

Garett

16.9k5 gold badges58 silver badges63 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

PostgreSQL exported csv file could not be read in ms Sql Server database

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related