load.sql

copy call_center            from './data/call_center_001.dat' WITH (HEADER 0, DELIMITER '|');
copy catalog_page           from './data/catalog_page_001.dat' WITH (HEADER 0, DELIMITER '|');
copy catalog_returns        from './data/catalog_returns_001.dat' WITH (HEADER 0, DELIMITER '|');
copy catalog_sales          from './data/catalog_sales_001.dat' WITH (HEADER 0, DELIMITER '|');
copy customer               from './data/customer_001.dat' WITH (HEADER 0, DELIMITER '|');
copy customer_address       from './data/customer_address_001.dat' WITH (HEADER 0, DELIMITER '|');
copy customer_demographics  from './data/customer_demographics_001.dat' WITH (HEADER 0, DELIMITER '|');
copy date_dim               from './data/date_dim_001.dat' WITH (HEADER 0, DELIMITER '|');
copy dbgen_version          from './data/dbgen_version_001.dat' WITH (HEADER 0, DELIMITER '|');
copy household_demographics from './data/household_demographics_001.dat' WITH (HEADER 0, DELIMITER '|');
copy income_band            from './data/income_band_001.dat' WITH (HEADER 0, DELIMITER '|');
copy inventory              from './data/inventory_001.dat' WITH (HEADER 0, DELIMITER '|');
copy item                   from './data/item_001.dat' WITH (HEADER 0, DELIMITER '|');
copy promotion              from './data/promotion_001.dat' WITH (HEADER 0, DELIMITER '|');
copy reason                 from './data/reason_001.dat' WITH (HEADER 0, DELIMITER '|');
copy ship_mode              from './data/ship_mode_001.dat' WITH (HEADER 0, DELIMITER '|');
copy store                  from './data/store_001.dat' WITH (HEADER 0, DELIMITER '|');
copy store_returns          from './data/store_returns_001.dat' WITH (HEADER 0, DELIMITER '|');
copy store_sales            from './data/store_sales_001.dat' WITH (HEADER 0, DELIMITER '|');
copy time_dim               from './data/time_dim_001.dat' WITH (HEADER 0, DELIMITER '|');
copy warehouse              from './data/warehouse_001.dat' WITH (HEADER 0, DELIMITER '|');
copy web_page               from './data/web_page_001.dat' WITH (HEADER 0, DELIMITER '|');
copy web_returns            from './data/web_returns_001.dat' WITH (HEADER 0, DELIMITER '|');
copy web_sales              from './data/web_sales_001.dat' WITH (HEADER 0, DELIMITER '|');
copy web_site               from './data/web_site_001.dat' WITH (HEADER 0, DELIMITER '|');