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

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 (view raw or flat)
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

pgsql-novice by date

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

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