Re: How to remove quotes from COPY TO result?

On 10 August 2010 00:53, Bruce Momjian <bruce(at)momjian(dot)us> wrote:
> Joe Conway wrote:
> -- Start of PGP signed section.
>> 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)
>
> How were the double-quotes removed?

Doesn't the "WITH ... CSV" handle that automatically?

The documentation implies to me that quotes would be stripped,
although it talks more about writing CSV files than reading them. I
haven't tried it, though.

--
Michael Wood <esiotrot(at)gmail(dot)com>