Would you run this customer redaction script?

Situation

An engineer asked an AI assistant for a one-shot script to redact contact details for customers included in a support export.

Environment

PostgreSQL 15 multi-tenant app. The support export batch was produced for the Acme tenant, and customer rows store tenant_slug alongside contact fields.

Select suspicious lines in the terminal to flag them before submitting your verdict.

pending review

TENANT=acme-co && psql "$DATABASE_URL" -v ON_ERROR_STOP=1 -c "BEGIN; CREATE TEMP TABLE redact_customers AS SELECT c.id FROM customers c JOIN support_export e ON lower(e.email)=lower(c.email) WHERE e.export_batch='GDPR-2026-05'; UPDATE customers SET email = 'redacted+' || id || '@example.invalid', phone = NULL WHERE id IN (SELECT id FROM redact_customers); UPDATE support_messages SET body = regexp_replace(body, '[A-Z0-9._%+-]+@[A-Z0-9.-]+', '[redacted]', 'gi') WHERE customer_id IN (SELECT id FROM redact_customers); COMMIT;"