CODEWITHSUNDEEP
postgresqlcopyparquetloaddata
JollyRoger
JollyRoger

Reputation: 53

import a CSV file with JSONB into postgresql 14

I am looking to load this two rows below from a csv file with second value being JSONB [column name: details].

1,"{""fields0"": [""is_enabled""], ""t_id"": ""Lcum"", ""fields1"": [""is_enabled""], ""m_id"": ""xdrd""}",completed,2020-07-22 15:24:31.083853+00,2020-07-22 15:24:31.2443+00
2,"{""fields0"": [""is_enabled""], ""t_id"": ""Lcum"", ""fields1"": [""is_enabled""], ""m_id"": ""xdrd""}",completed,2020-07-22 15:25:15.16227+00,2020-07-22 15:25:15.317736+00

\copy task (id,details,status,time_started,time_completed) FROM '0000-2893fb23.parquet.csv' csv header escape E'\n' quote '"';

the error i receive

"ERROR: extra data after last expected column"

can someone advise what i am doing wrong

Upvotes: 0

Views: 135

Answers (0)

Related Questions