#!/bin/sh
# Владелец всех таблиц public → POSTGRES_USER (после всех *.sql).
set -eu
psql -v ON_ERROR_STOP=1 --username "postgres" --dbname "$POSTGRES_DB" <<-EOSQL
DO \$\$
DECLARE
  t text;
BEGIN
  FOR t IN SELECT tablename FROM pg_tables WHERE schemaname = 'public'
  LOOP
    EXECUTE format('ALTER TABLE IF EXISTS %I OWNER TO %I', t, '${POSTGRES_USER}');
  END LOOP;
END \$\$;
EOSQL