First, you need
PGToTxt is a tool to batch unload PostgreSQL data to TXT files.
Using PGToTxt you can batch unload PostgreSQL data to TXT files easily and fast.
More about PGToTxt – the tool to batch unload data from PostgreSQL tables data to TXT files
PostgreSQL → TXT reference
Type mapping
| Value kind | in PostgreSQL | in TXT |
|---|---|---|
| Int | integer | 1234, or right-aligned in a fixed-width column |
| Bigint | bigint | 9007199254740993 |
| Decimal | numeric(p,s) | 1234.56 |
| Float | double precision | 1.234e+10 |
| Text | varchar(n) | written as-is; padding depends on the chosen layout |
| Long text | text | written as-is |
| Date | date | whatever the writer chose |
| Datetime | timestamp | whatever the writer chose |
| Binary | bytea | not representable |
| Boolean | boolean | Y / N, or 1 / 0, or TRUE / FALSE |
| JSON | jsonb | written as-is |
Dialect differences
PostgreSQL is a database server and TXT is a file format, so the gap is wider than a dialect difference - the rows below are where values and structure stop lining up.
| Property | in PostgreSQL | in TXT |
|---|---|---|
| port | 5432 | — |
| identifiers | "double quotes" | None by convention |
| row limit | LIMIT n | — |
| dates | timestamp, timestamptz, date, time | Whatever the writer produced; no convention is guaranteed |
| long text | TEXT | — |
| binary | BYTEA | Not supported |
| separator | — | Whatever was chosen - often fixed column widths |
| encoding | — | No declaration - UTF-8 works only with a BOM |
| typing | — | None - every field is text |
| shape | Tables of rows and columns | Free form; a parser has to be told the layout |
| ceiling | — | No formal limit |
Command line
| Side | Command |
|---|---|
| PostgreSQL | pg_dump or COPY ... TO |
| PostgreSQL (load) | COPY ... FROM |
Convert your data online, free
Free in-browser converters for CSV, Excel, JSON, XML and SQL: Withdata Online Data Conversion. Large files, batch conversion or scheduling? See the offline desktop apps, or browse all data conversion tools.