I'm using the following to backup a table from a database pg_dump --table=tableName --clean --format p dbName The file produced has all lines preceded by a space. Only the COPY such as this ... COPY rr_config (a, b, c, d, e, f, g, h, i, j, k, l, m, n, o) FROM stdin; 69 2 \N \N mydevice ahash 1 \N \N mydevice#10.86.209.205 \N \N \N 68 63 \. seems to care. I get these errors: ERROR: copy: line 2, Bad numeric input format ' ' lost synchronization with server, resetting connection manually removing the space before the "\." fixes the problem. Is there a workaround? Thanks, Frank
pgsql-novice by date:
Соглашаюсь с условиями обработки персональных данных