importing tab delimited, text enclosed by "

From: Andrew Gould <andrewgould(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: importing tab delimited, text enclosed by "
Date: 2000-09-26 16:08:40
Message-ID: 20000926160840.16077.qmail@web109.yahoomail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have a file of data that is tab delimited, with text
fields enclosed by quotation marks.

I know I can use the copy command to load the data;
and that tab delimited is the default. How do I tell
Postgres to remove the quotation marks?

I'm running PostgreSQL 7.0.2 on Linux (Caldera
eDesktop 2.4)

Thanks,

Andrew Gould

__________________________________________________
Do You Yahoo!?
Send instant messages & get email alerts with Yahoo! Messenger.
http://im.yahoo.com/

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Edward Q. Bridges 2000-09-26 16:50:38 Re: web programming
Previous Message Alfred Perlstein 2000-09-26 15:38:08 Re: FreeBSD Softupdates??