-4

Trying to match data types, but cannot find the right match.

I have a CSV file with the following sample data:

fig_num,name,num_parts,img_url
fig-000001,Toy Store Employee,4,https://cdn.rebrickable.com/media/sets/fig-000001.jpg
fig-000002,Customer Kid,4,https://cdn.rebrickable.com/media/sets/fig-000002.jpg
fig-000003,"Assassin Droid, White",8,https://cdn.rebrickable.com/media/sets/fig-000003.jpg
fig-000004,"Man, White Torso, Black Legs, Brown Hair",4,https://cdn.rebrickable.com/media/sets/fig-000004.jpg
fig-000005,Captain America with Short Legs,3,https://cdn.rebrickable.com/media/sets/fig-000005.jpg
fig-000006,Lloyd Avatar,5,https://cdn.rebrickable.com/media/sets/fig-000006.jpg

I am importing it into PostgreSQL. What data types should I use for each column? CSV is comma-delimited.

Improve this question
New contributor
Jeff Sharp is a new contributor to this site. Take care in asking for clarification, commenting, and answering. Check out our Code of Conduct.
Related questions
1170
When should I use curly braces for ES6 import?
227
Ruby on Rails - Import Data from a CSV file
56
How should I import data from CSV into a Postgres table using pgAdmin 3?
Load 4 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.