text: 
  	CREATE TABLE PART (
  
  		P_PARTKEY		INT,
  		P_NAME			VARCHAR(55),
  		P_MFGR			CHAR(25),
  		P_BRAND			CHAR(10),
  		P_TYPE			VARCHAR(25),
  		P_SIZE			INTEGER,
  		P_CONTAINER		CHAR(10),
  		P_RETAILPRICE	DECIMAL,
  		P_COMMENT		VARCHAR(23)
  	);
  
  	COPY part FROM LOCAL './tpch-data/part.csv' DELIMITER '|';
  
  	CREATE TABLE REGION (
  		R_REGIONKEY	INT,
  		R_NAME		CHAR(25),
  		R_COMMENT	VARCHAR(152)
  	);
  
  	COPY region FROM LOCAL './tpch-data/region.csv' DELIMITER '|';
  
  	CREATE TABLE NATION (
  		N_NATIONKEY		INT,
  		N_NAME			CHAR(25),
  		N_REGIONKEY		BIGINT NOT NULL,  -- references R_REGIONKEY
  		N_COMMENT		VARCHAR(152)
  	);
  
  	COPY nation FROM LOCAL './tpch-data/nation.csv' DELIMITER '|';
  
  	CREATE TABLE SUPPLIER (
  		S_SUPPKEY		INT,
  		S_NAME			CHAR(25),
  		S_ADDRESS		VARCHAR(40),
  		S_NATIONKEY		BIGINT NOT NULL, -- references N_NATIONKEY
  		S_PHONE			CHAR(15),
  		S_ACCTBAL		DECIMAL,
  		S_COMMENT		VARCHAR(101)
  	);
  
  	COPY supplier FROM LOCAL './tpch-data/supplier.csv' DELIMITER '|';
  
  	CREATE TABLE CUSTOMER (
  		C_CUSTKEY		INT,
  		C_NAME			VARCHAR(25),
  		C_ADDRESS		VARCHAR(40),
  		C_NATIONKEY		BIGINT NOT NULL, -- references N_NATIONKEY
  		C_PHONE			CHAR(15),
  		C_ACCTBAL		DECIMAL,
  		C_MKTSEGMENT	CHAR(10),
  		C_COMMENT		VARCHAR(117)
  	);
  
  	COPY customer FROM LOCAL './tpch-data/customer.csv' DELIMITER '|';
  
  	CREATE TABLE PARTSUPP (
  		PS_PARTKEY		BIGINT NOT NULL, -- references P_PARTKEY
  		PS_SUPPKEY		BIGINT NOT NULL, -- references S_SUPPKEY
  		PS_AVAILQTY		INTEGER,
  		PS_SUPPLYCOST	DECIMAL,
  		PS_COMMENT		VARCHAR(199)
  	);
  
  	COPY partsupp FROM LOCAL './tpch-data/partsupp.csv' DELIMITER '|';
  
  	CREATE TABLE ORDERS (
  		O_ORDERKEY		INT,
  		O_CUSTKEY		BIGINT NOT NULL, -- references C_CUSTKEY
  		O_ORDERSTATUS	CHAR(1),
  		O_TOTALPRICE	DECIMAL,
  		O_ORDERDATE		DATE,
  		O_ORDERPRIORITY	CHAR(15),
  		O_CLERK			CHAR(15),
  		O_SHIPPRIORITY	INTEGER,
  		O_COMMENT		VARCHAR(79)
  	);
  
  	COPY orders FROM LOCAL './tpch-data/orders.csv' DELIMITER '|';
  
  	CREATE TABLE LINEITEM (
  		L_ORDERKEY		BIGINT NOT NULL, -- references O_ORDERKEY
  		L_PARTKEY		BIGINT NOT NULL, -- references P_PARTKEY (compound fk to PARTSUPP)
  		L_SUPPKEY		BIGINT NOT NULL, -- references S_SUPPKEY (compound fk to PARTSUPP)
  		L_LINENUMBER	INTEGER,
  		L_QUANTITY		DECIMAL,
  		L_EXTENDEDPRICE	DECIMAL,
  		L_DISCOUNT		DECIMAL,
  		L_TAX			DECIMAL,
  		L_RETURNFLAG	CHAR(1),
  		L_LINESTATUS	CHAR(1),
  		L_SHIPDATE		DATE,
  		L_COMMITDATE	DATE,
  		L_RECEIPTDATE	DATE,
  		L_SHIPINSTRUCT	CHAR(25),
  		L_SHIPMODE		CHAR(10),
  		L_COMMENT		VARCHAR(44)
  	);
  
  	COPY lineitem FROM LOCAL './tpch-data/lineitem.csv' DELIMITER '|';
  