From: | Joe Conway <mail(at)joeconway(dot)com> |
---|---|
To: | Michael Rowan <mike(dot)rowan(at)internode(dot)on(dot)net> |
Cc: | postgresql novice <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: How to remove quotes from COPY TO result? |
Date: | 2010-07-18 06:44:13 |
Message-ID: | 4C42A2BD.30809@joeconway.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
On 07/17/2010 09:45 PM, Michael Rowan wrote:
> PostgreSQL 8.4.1
>
> I have a table "abbreviation" created as follows:
>
> id serial NOT NULL, full_name character varying(16), short_name
> character varying(16),
>
> I import some data from a tab delimited text file like so:
>
> 1 "STREET" "ST" 2 "ROAD" "RD"
>
> using COPY abbreviation FROM <<myfile>>
>
> The data is imported but I want the character columns to be stripped
> of the enclosing double-quotes and they are not. What do I have to
> do?
See:
http://www.postgresql.org/docs/8.4/interactive/sql-copy.html
COPY abbreviation FROM 'filename' WITH DELIMITER '\t' CSV;
select * from abbreviation;
id | full_name | short_name
----+-----------+------------
1 | STREET | ST
2 | ROAD | RD
(2 rows)
HTH,
Joe
--
Joe Conway
credativ LLC: http://www.credativ.us
Linux, PostgreSQL, and general Open Source
Training, Service, Consulting, & 24x7 Support
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Rowan | 2010-07-18 09:00:48 | Re: How to remove quotes from COPY TO result? |
Previous Message | Michael Rowan | 2010-07-18 04:45:58 | How to remove quotes from COPY TO result? |