Database files

PostgreSQL COPY text encoder

Encode string/null rows for tab-delimited PostgreSQL COPY text input.

Your inputs

Start with an example

Your inputs stay in your browser.

Your result

Example result

How it works

Use literal \N for null, escape backslashes and control separators in strings, and end each row with LF.

A tab inside a cell becomes the two-character escape \t; the real tab remains the column separator.

Limits

Default COPY text settings only: tab delimiter, \N null marker and UTF-8. Equal column counts are required. No SQL command, CSV mode, database connection or end-of-data marker is included.