When I do this:
cat data/images_pgsql.sql |psql -U zabbix zabbix
I get alot of this
HINT: Use the escape string syntax for backslashes, e.g., E'\\'.
ERROR: duplicate key value violates unique constraint "images_pkey"
WARNING: nonstandard use of \\ in a string literal
LINE 1: ...RT INTO images VALUES (20,1,'Workstation (small)','\\211PNG\...
Is there a smarter way I should be loading it?
cat data/images_pgsql.sql |psql -U zabbix zabbix
I get alot of this
HINT: Use the escape string syntax for backslashes, e.g., E'\\'.
ERROR: duplicate key value violates unique constraint "images_pkey"
WARNING: nonstandard use of \\ in a string literal
LINE 1: ...RT INTO images VALUES (20,1,'Workstation (small)','\\211PNG\...
Is there a smarter way I should be loading it?