copy from ???
I'm trying to import a text file into the database. The file is coma
delimeted and there are newlines, but I want them to be ignored. You can
have newlines in a field correct? I can't find any good examples of using
copy from. I tried copy table from 'file' using delimeters ','; but it
still uses newlines. Does anyone know how to do this?
Nate
But if you use newlines as data, how will PostgreSQL
know when one row stops and another begins? Are you
only importing data into one row?
Maybe I'm misunderstanding something.
Andrew Gould
--- Nate Haggard <nate@wordplace.com> wrote:I'm trying to import a text file into the database.
The file is coma
delimeted and there are newlines, but I want them to
be ignored. You can
have newlines in a field correct? I can't find any
good examples of using
copy from. I tried copy table from 'file' using
delimeters ','; but it
still uses newlines. Does anyone know how to do
this?Nate
---------------------------(end of
broadcast)---------------------------
TIP 6: Have you searched our list archives?
__________________________________________________
Do You Yahoo!?
Send your FREE holiday greetings online!
http://greetings.yahoo.com