Skip site navigation (1) Skip section navigation (2)

Re: Importing an ASCII file

From: Francisco Reyes <lists(at)natserv(dot)com>
To: Andrew McMillan <andrew(at)catalyst(dot)net(dot)nz>
Cc: Pgsql Novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Importing an ASCII file
Date: 2001-09-10 15:49:55
Message-ID: 20010910114627.I24979-100000@zoraida.natserv.net (view raw or flat)
Thread:
Lists: pgsql-novice
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
I need).


pgsql-novice by date

Next:From: G.LeeJDate: 2001-09-10 16:42:33
Subject: does not exist
Previous:From: Vijay DevalDate: 2001-09-09 05:06:43
Subject: Re: Importing an ASCII file

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group