Re: Off topic? - Solution for a delimiter problem - Mailing list pgsql-general

From Poul L. Christiansen
Subject Re: Off topic? - Solution for a delimiter problem
Date
Msg-id 3A4131F6.C26AF3B6@cs.auc.dk
Whole thread Raw
In response to Off topic? - Solution for a delimiter problem  (Andrew Gould <andrewgould@yahoo.com>)
List pgsql-general
Maybe you can specify the delimiter to be space.

radius=# \h copy
Command:     COPY
Description: Copies data between files and tables
Syntax:
COPY [ BINARY ] table [ WITH OIDS ]
    FROM { 'filename' | stdin }
    [ [USING] DELIMITERS 'delimiter' ]
    [ WITH NULL AS 'null string' ]
COPY [ BINARY ] table [ WITH OIDS ]
    TO { 'filename' | stdout }
    [ [USING] DELIMITERS 'delimiter' ]
    [ WITH NULL AS 'null string' ]

That would probably be COPY table FROM filename USING DELIMITERS ' ';

HTH,
Poul L. Christiansen

Andrew Gould wrote:

> I receive space delimited files that have spaces
> within double quoted text fields.
>
> Since PostgreSQL's COPY doesn't deal with multiple
> delimiters, I've written a crude Python script to
> convert the files to a tab delimited format without
> the double quotes and without disturbing the spaces
> within text fields.  I'm sure someone could make it
> more efficient.  (Probably by rewriting it in Perl.)
>
> Does anyone else need the script?  Is the script
> something I can/should post?
>
> Andrew Gould
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! Shopping - Thousands of Stores. Millions of Products.
> http://shopping.yahoo.com/


pgsql-general by date:

Previous
From: Andrew Gould
Date:
Subject: Off topic? - Solution for a delimiter problem
Next
From: Mirko Zeibig
Date:
Subject: Best way to replicate a DB between two servers (master/slave)