CODEWITHSUNDEEP
postgresqlcsvcopycstore-fdw
Alexandre S.
Alexandre S.

Reputation: 540

Bug during COPY in Postgres

I have a table named basic_data which contains more than 8 millions rows and I want to copy all this data into a CSV file.

So I use the COPY command like this :

copy basic_data to '/tmp/data_fdw.csv' delimiter ';' null ''; COPY 8792481

This work great but when I want to insert my data into another table with exactly the same schema (but it's a foreign table), I had this following error:

ERROR: value out of range: overflow

Upvotes: 0

Views: 65

Answers (0)

Related Questions