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
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 |