
January 17th, 2013, 04:30 PM
|
|
Registered User
|
|
Join Date: Jan 2013
Posts: 1
Time spent in forums: 15 m 40 sec
Reputation Power: 0
|
|
|
Import CSV into postgres, comma problem
Hi,
I am trying to copy some data from a csv into postgres. I am using the 'copy' syntax, which imports data fine but gives problems on comma. For example: The text in 1 csv cell is like the following: (Note: the following text would be in 1 cell).
Bird's Head, P. Waar, Philip
I tried the following (adding slash before comma)
Bird's Head/, P. Waar/, Philip
But my result in Data Base has quotes in the cell like following.
"Bird's Head, P. Waar, Philip"
I dont want quotes in a cell.
Can someone please help me get the same format in database table like in csv? which is
Bird's Head, P. Waar, Philip
Thanks
Susan
|