Hi all, I'm trying to use \copy to import a csv file and I'm getting this error:
DB.run "\copy user (name, surname) from /home/gramos/download/my_file.csv DELIMITER '|'" E, [2012-12-10T09:41:54.992473 #22222] ERROR -- : PG::Error: ERROR: syntax error at or near "\" and when I try COPY from command DB.run "COPY user (name, surname) FROM '/home/gramos/download/my_file.csv' DELIMITER '|'" E, [2012-12-10T09:45:44.456877 #22222] ERROR -- : PG::Error: ERROR: must be superuser to COPY to or from a file HINT: Anyone can COPY to stdout or from stdin. psql's \copy command also works for anyone.: I'm using postgresql-9.1 and sequel 3.35.0 any idea about this? Cheers -- You received this message because you are subscribed to the Google Groups "sequel-talk" group. To view this discussion on the web visit https://groups.google.com/d/msg/sequel-talk/-/qXp1acuQCHwJ. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/sequel-talk?hl=en.
