Thread: 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?
>
> http://archives.postgresql.org


__________________________________________________
Do You Yahoo!?
Send your FREE holiday greetings online!
http://greetings.yahoo.com