Re: Importing an ASCII file

From: jik(at)foxinternet(dot)net
To: psql <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Importing an ASCII file
Date: 2001-09-06 19:03:57
Message-ID: 3B97C89D.6F519E1B@foxinternet.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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 "?
> Mean time I am going to try and take out the " using one of the Unix
> tools.
>
> Didn't see anything on the FAQ on importing data from ASCII files. Isn't
> this an FAQ?

Couldn't you pipe it through tr?

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message David Mulcahy 2001-09-06 19:41:44 pl/pgsql function problem
Previous Message Francisco Reyes 2001-09-06 16:08:01 Importing an ASCII file