Are reserved words quoted?

Yes. Table and column names that contain spaces, uppercase letters, or reserved words are wrapped in double quotes.

How are booleans emitted?

As TRUE or FALSE, matching PostgreSQL's boolean literals.

When an entire column is numeric it is emitted without quotes; the Detected types line shows what was inferred.

Can I keep the output consistent across a team?

Signed-in accounts remember your preferred dialect, so the same setting loads on another device.

PostgreSQL INSERT statement generator

In PostgreSQL mode the generator uses double-quoted identifiers for names that need quoting, and writes booleans as TRUE and FALSE. Values are type-inferred per column, so a column of integers is emitted without quotes while mixed text keeps its quotes.

Because it runs client-side, this is safe for production data dumps that you would not paste into a random online tool.

SQL INSERT

Drop a file to generate INSERT statements

Processing stays in this browser. Guests can process up to 500 rows per file.

How to use this tool

1Drop a CSV, Excel, JSON, or TSV file.
2Keep Dialect on PostgreSQL.
3Review the detected types per column.
4Copy or download the SQL.

Frequently asked questions

Are reserved words quoted?: Yes. Table and column names that contain spaces, uppercase letters, or reserved words are wrapped in double quotes.
How are booleans emitted?: As TRUE or FALSE, matching PostgreSQL's boolean literals.
Are numbers quoted?: When an entire column is numeric it is emitted without quotes; the Detected types line shows what was inferred.
Can I keep the output consistent across a team?: Signed-in accounts remember your preferred dialect, so the same setting loads on another device.

Private by design

This tool runs entirely in your browser. Files, tables, and results are never uploaded to a server — you can even disconnect your network and keep working. See the Privacy Policy.