I have been trying for days to copy a large CSV file to a table in PostgreSQL I am using PGadmin4 to access the database. I have a file on my system the file is 10 GB so I am getting starting error when trying to upload it via UI or \copy command.
Asked
Active
Viewed 216 times
-1
-
1Please show the actual error message, not your paraphrasing of it. – jjanes Jul 09 '21 at 18:31
-
hey sorry, It was a database issue able to solve it – aadi sharma Jul 12 '21 at 03:16
1 Answers
1
When talking about 10 GB CSV file, then you may use as well different options
I believe
\copyshould work, you did not provide any more information about the issueI'd personally use the AWS Glue - an ETL service which could read from an S3 file
gusto2
- 11,210
- 2
- 17
- 36