pg.sql

-- Create database assignment
SELECT 'CREATE DATABASE assignment'
WHERE NOT EXISTS (SELECT FROM pg_database WHERE datname = 'assignment')\gexec

-- Switch DATABASE

\c assignment

--
-- Name: categories; Type: TABLE; Owner: -; Tablespace:
--
CREATE TABLE rides (
  ride_id character varying(32) not null,
  driver_id integer not null,
  passenger_id integer not null,
  started_at timestamp not null,
  PRIMARY KEY (ride_id)
);

COPY rides(ride_id, driver_id, passenger_id, started_at)
FROM '/tmp/corrected_data.csv'
DELIMITER ','
CSV HEADER;