CSV SafePreview · PostgreSQL import guides

Check a CSV before PostgreSQL COPY

PostgreSQL COPY depends on the CSV dialect: header handling, delimiter, quote rules, NULL tokens, line endings, and row shape. SafePreview lets you inspect those assumptions and optionally compare the source headers/types against a small destination contract entirely in your browser.

Local workflow: diagnose the CSV, review inferred types and transport notes, check a destination contract if you have one, then generate a conservative SQL preview. No database connection or import is performed.

What to review before COPY

Whether the producing system uses comma, tab, semicolon, or another delimiter
Whether HEADER, quoted fields, empty strings, and NULL tokens match the destination
Whether every row has the expected number of columns
Whether inferred integer, numeric, boolean, or text types match the target table

Destination contract checks

The optional contract format checks column names, order, types, nullability, uniqueness, and allowed values. Findings are warnings or blockers for review; the tool does not silently rename, coerce, drop, or upload data.

Run a local CSV preflight →Read the CSV import preflight guide CSV to PostgreSQL without upload

Privacy and limits: text and files are read locally. The browser cannot prove source encoding, schema correctness, referential integrity, migration safety, or production-import readiness.