SQL Portfolio Project Walkthrough | PostgreSQL + Tableau | Data Prep, Analysis and Visualisation

[@edaa1861]

hi, can you write a script for to creating tables for parts on lego project in postgresql please? ı tried this scprit CREATE TABLE parts (
part_num varchar(250),
name varchar(250) DEFAULT NULL,
part_cat_id int4 DEFAULT NULL
); but when ı run the scrpit it says : ERROR: unterminated CSV quoted field
CONTEXT: COPY parts, line 25995: "3008p03,"Brick 1 x 8 with Black 'GARAGE' Sans-Serif Thick Print, Plain 'G'",2
3008p04,Brick 1 x 8 wi..."

[@wjsutton]

Hey I’ve got the script saved here:
github.com/wjsutton/lego_analysis_challenge/blob/main/solutions/1_create_analysis_schema.sql

[@billedwards6492]

thank u