From: | Andrew Gould <andrewgould(at)yahoo(dot)com> |
---|---|
To: | Nate Haggard <nate(at)wordplace(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: copy from ??? |
Date: | 2002-01-03 03:01:39 |
Message-ID: | 20020103030139.81400.qmail@web13402.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)wordplace(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Trombley | 2002-01-03 03:15:47 | Re: SERIAL or INT8 / Unique BLOB's |
Previous Message | Tom Lane | 2002-01-03 02:54:13 | Re: SERIAL or INT8 / Unique BLOB's |