Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search archives
  Advanced Search

copy csv eclosed by analog quotes problem superuser ?



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

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group