環境
- PostgreSQL 9.6
- Windows 10
https://gist.github.com/michhar/2dfd2de0d4f8727f873422c5d959fff5
CREATE TABLE titanic ( passengerid INTEGER NOT NULL, survived SMALLINT NOT NULL, pclass INTEGER NOT NULL, name VARCHAR(82) NOT NULL, sex VARCHAR(6) NOT NULL, age DECIMAL(4, 2), sibsp INTEGER NOT NULL, parch INTEGER NOT NULL, ticket VARCHAR(18) NOT NULL, fare DECIMAL(7, 4) NOT NULL, cabin VARCHAR(15), embarked VARCHAR(1), CHECK (survived IN (0, 1)), CONSTRAINT titanic_pkey PRIMARY KEY (passengerid) ); -- tab区切り、ヘッダ行を無視する COPY titanic FROM '/tmp/titanic.csv' delimiter ' ' csv header;