copy from ???

From: Nate Haggard <nate(at)wordplace(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: copy from ???
Date: 2002-01-03 00:28:51
Message-ID: 4.3.2.7.0.20020102172607.00b94768@pop.wordplace.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jeffrey W. Baker 2002-01-03 00:55:11 Re: SERIAL or INT8 / Unique BLOB's
Previous Message Richard Teviotdale 2002-01-02 23:47:16 SERIAL or INT8 / Unique BLOB's