-- 16_bulk_insert_copy_payments.sql
-- Banking Pattern Pack — PostgreSQL
-- Purpose: COPY bulk loading of payment files.
-- Context: Retail bank example with customers, accounts, transactions, cards, loans.
-- Date: 2025-08-18
-- Notes:
--   * Safe to read; run on a development DB.
--   * Requires: CREATE privileges; some files may need superuser for extensions.
--   * Search path set to 'bank' schema for clarity.
SET search_path = bank, public;

-- COPY example (run \copy in psql for client‑side)
-- \copy bank.transactions(account_id, amount, tx_type, description) FROM '/path/payments.csv' CSV HEADER;
-- \copy bank.transactions TO '/path/tx_export.csv' CSV HEADER;
