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: Sat, 24 Dec 2005 14:45:30 +0200
- Message-id: <op(dot)s2agd4u4x97onz(at)keskkripokeke(dot)starman(dot)ee>
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
Home |
Main Index |
Thread Index