copy csv eclosed by analog quotes problem superuser ?

From: Eugene <evgenius(at)hot(dot)ee>
To: pgsql-general(at)postgresql(dot)org
Subject: copy csv eclosed by analog quotes problem superuser ?
Date: 2005-12-24 12:45:30
Message-ID: op.s2agd4u4x97onz@keskkripokeke.starman.ee
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

hello!
I have IP CSV, it is huge CSV with quotes
"69110784","69111807","US","UNITED
STATES","ILLINOIS","BLOOMINGTON","40.4758","-88.9894","61701","LEVEL 3
COMMUNICATIONS INC","DSL-VERIZON.NET"
"69111808","69112831","US","UNITED
STATES","TEXAS","GRAPEVINE","32.9309","-97.0755","76051","LEVEL 3
COMMUNICATIONS INC","DSL-VERIZON.NET"

In my sql there is enclosed by command, i can do this way
mysql> LOAD DATA INFILE
"<path>/IP-COUNTRY-REGION-CITY-LAT-LONG-ZIPCODE-ISP-DOMAIN.CSV" INTO TABLE
IPCITYLATLONGISPDOMAIN FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES
TERMINATED BY '\r\n';

ENCLOSED BY '"' helps in mysql

1.in postgresql I can't do COPY WITH CSV, it says superuser needed
2. i can use is [\copy] but it wont help me, I get syntax error
3. i can't convert current csv into csv without quotes

it is like a death circle ...

what should I do?

--

----------------
eugene

Responses

Browse pgsql-general by date

  From Date Subject
Next Message markc 2005-12-24 12:48:39 Login username char length
Previous Message robert mena 2005-12-24 12:41:49 Re: newbie : setting access for users in a web enviroment