On Monday, December 10, 2012 5:06:55 AM UTC-8, Gastón Ramos wrote:
>
> 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?
>
First, COPY with a filename specifies a filename on the server, not on the
client, which is why you need to be a superuser to use it. I'm guessing
the file you are trying to use is on the client, so you can't do that. If
the file actually is on the server, that DB.run command should work if you
are a superuser and the database system user has appropriate permissions to
the file.
Second, with Sequel you need to use DB.copy_into for COPY FROM STDIN.
Maybe something like this:
DB.copy_into(:user, :columns=>[:name, :surname],
:data=>File.new("/home/gramos/download/my_file.csv", "rb"),
:options=>"DELIMITER '|'")
Jeremy
--
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/-/b076gQdeZV0J.
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.
