Ad Widget

Collapse

Help Loading Images - Postgres

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • bignose
    Member
    • Dec 2008
    • 58

    #1

    Help Loading Images - Postgres

    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?
Working...