Re: Importing an ASCII file - Mailing list pgsql-novice

From jik@foxinternet.net
Subject Re: Importing an ASCII file
Date
Msg-id 3B97C89D.6F519E1B@foxinternet.net
Whole thread Raw
In response to Importing an ASCII file  (Francisco Reyes <lists@natserv.com>)
List 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?

pgsql-novice by date:

Previous
From: Francisco Reyes
Date:
Subject: Importing an ASCII file
Next
From: David Mulcahy
Date:
Subject: pl/pgsql function problem