hi david,
Thanks for all the help . following those steps helped.
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/copymanager-question-tp5817197p5817425.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
--
Sent via pgsql-general mailing
Thanks for getting back.
So just to confirm if a string value , we need to take care off it ourselves
by escaping
any special character and quote (single, double) ? I am not exactly sure off
the escaping part
for each of the characters - have read that for single quotes, we need to
add one more
one more - i also need to insert useragent strings which have all sorts of
characters in them eg
Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US) AppleWebKit/525.13 (KHTML,
like Gecko) Chrome/0.2.149.29 Safari/525.13
Here there is a comma which causes the copy to fail. Other words do not have
comma
Hello all
I am using cm instead of preparedstmts for faster inserts . But have a
question on inserting
values which have quotes in them (maybe single or double). Using
preparedstmts, we know
its safe to do so by calling setString. Is it possible to do the same here
as i do not want
to blindly sin
In need of some help - The use case is to insert current time in UTC for a
timestamp column
using COPY command . It works fine if i just have now() in csv file input.
But if i add
now() at time zone 'utc' it gives the error as
ERROR: invalid input syntax for type timestamp: "now() at time zone
