load_data.sql

-- ============================================================================
-- Load the generated CSVs into Supabase/Postgres.
--
-- Run schema.sql FIRST. Then either:
--   (a) Use the Supabase Table Editor's "Import data from CSV" button per
--       table (easiest, no local psql needed), or
--   (b) Run this file with psql if you have direct DB access:
--         psql "$DATABASE_URL" -f sql/load_data.sql
--       (run from the repo root so the relative paths resolve)
-- ============================================================================

\copy product_master from 'data/product_master.csv' with (format csv, header true);
\copy store_master from 'data/store_master.csv' with (format csv, header true);
\copy sales_promotions from 'data/sales_promotions.csv' with (format csv, header true);
\copy inventory from 'data/inventory.csv' with (format csv, header true);