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
Views: Raw Message | Whole Thread | Download mbox
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