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

Importing an ASCII file

From: Francisco Reyes <lists(at)natserv(dot)com>
To: Pgsql Novice <pgsql-novice(at)postgresql(dot)org>
Subject: Importing an ASCII file
Date: 2001-09-06 16:08:01
Message-ID: 20010906120604.Q2745-100000@zoraida.natserv.net (view raw or flat)
Thread:
Lists: pgsql-novice
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?



Responses

pgsql-novice by date

Next:From: jikDate: 2001-09-06 19:03:57
Subject: Re: Importing an ASCII file
Previous:From: Francisco ReyesDate: 2001-09-06 14:21:25
Subject: What is syntax to use \i to include files?

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