import_data.sql

/* importing geo_location data */
COPY geo_location
FROM '/home/nabeel/Github/olist_database_analysis/olist_data/olist_geolocation_dataset.csv'
WITH (FORMAT CSV, HEADER);



/* importing customers data */
COPY customers
FROM '/home/nabeel/Github/olist_database_analysis/olist_data/olist_customers_dataset.csv'
WITH (FORMAT CSV, HEADER);


/* importing sellers data */
COPY sellers
FROM '/home/nabeel/Github/olist_database_analysis/olist_data/olist_sellers_dataset.csv'
WITH (FORMAT CSV, HEADER);



/* importing products data */
COPY products
FROM '/home/nabeel/Github/olist_database_analysis/olist_data/olist_products_dataset.csv'
WITH (FORMAT CSV, HEADER);


/* importing orders data */
COPY orders
FROM '/home/nabeel/Github/olist_database_analysis/olist_data/olist_orders_dataset.csv'
WITH (FORMAT CSV, HEADER);

/* importing order payments data */
COPY order_payments
FROM '/home/nabeel/Github/olist_database_analysis/olist_data/olist_order_payments_dataset.csv'
WITH (FORMAT CSV, HEADER);


/* importing order reviews data */
COPY order_reviews
FROM '/home/nabeel/Github/olist_database_analysis/olist_data/olist_order_reviews_dataset.csv'
WITH (FORMAT CSV, HEADER);

/* importing order items data */
COPY order_items
FROM '/home/nabeel/Github/olist_database_analysis/olist_data/olist_order_items_dataset.csv'
WITH (FORMAT CSV, HEADER);

/* importing product translation */
COPY product_translation
FROM '/home/nabeel/Github/olist_database_analysis/olist_data/product_category_name_translation.csv'
WITH (FORMAT CSV, HEADER);