Re: How to remove quotes from COPY TO result?

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?

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + It's impossible for everything to be true. +