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

Re: How to remove quotes from COPY TO result?

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

In response to

Responses

pgsql-novice by date

Next:From: Michael RowanDate: 2010-07-18 09:00:48
Subject: Re: How to remove quotes from COPY TO result?
Previous:From: Michael RowanDate: 2010-07-18 04:45:58
Subject: How to remove quotes from COPY TO result?

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