init.sql 286 B

1234567891011
  1. CREATE TABLE IF NOT EXISTS acceptance_customers (
  2. id BIGINT PRIMARY KEY,
  3. customer_name VARCHAR(100) NOT NULL
  4. );
  5. INSERT INTO acceptance_customers (id, customer_name)
  6. VALUES
  7. (1, 'Alpha'),
  8. (2, 'Beta')
  9. ON CONFLICT (id) DO UPDATE
  10. SET customer_name = EXCLUDED.customer_name;