1

I have a csv file with 7 columns. 6th column has value like "A,B,C" and 7th column has numbers, rest of the columns has int and text. While importing, 6th column is taking value A and 7th column with value B, but it should be like 6th column with ABC and 7th with int.

Improve this question
4
  • Should be a setting for Text Qualifier, you need to set that to use quotes. Commented Jul 31, 2019 at 18:28
  • What method are you using for importing? Commented Jul 31, 2019 at 18:44
  • If you are using the Import option, there should be a Quote Options tab. But as @tim said, what method are you using? Commented Jul 31, 2019 at 18:46
  • Also this thread should help you. Commented Jul 31, 2019 at 18:46
Related questions
2
Importing CSV file into PostgreSQL
14
Ignore quotation marks when importing a CSV file into PostgreSQL?
1
Import csv file into psql db
Load 7 more related questions Show fewer related questions

0

Reset to default

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.