On 9 Sep 2001, Andrew McMillan wrote:
> On Fri, 2001-09-07 at 04:08, Francisco Reyes wrote:
> > I have an ASCII file with fields separated by tabs.
> > My only issue is that text fields are enclosed with "
> > Is there a way to tell Postgresql to ignore those "?
> > Didn't see anything on the FAQ on importing data from ASCII files. Isn't
> > this an FAQ?
> I have a perl script which handles this sort of thing, but in my use it
> was comma-delimited rather than tab delimited, so would need some
> minimal change.
yes, at your convenience please send it.
My problem was two fold. First I didn't know what command was needed to do
the import (copy from). I was surprised to NOT find this info on the FAQ.
I thought this would have been a FAQ.
The second problem were the quotes. Given that the data was coming from a
Foxpro table I just ended up creating a Foxpro program to spit out the
data the way I needed.
There are DBF to PostgreSQL converters, but the Foxpro program gives me
the most flexibility and speed (no need to copy all fields, only the ones
pgsql-novice by date
|Next:||From: G.LeeJ||Date: 2001-09-10 16:42:33|
|Subject: does not exist|
|Previous:||From: Vijay Deval||Date: 2001-09-09 05:06:43|
|Subject: Re: Importing an ASCII file|