csv files

From: Dennis Gearon <gearond(at)cvc(dot)net>
To: postgresql <pgsql-general(at)postgresql(dot)org>
Subject: csv files
Date: 2003-04-09 18:34:57
Message-ID: 3E9467D1.8040504@cvc.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Any major gotcha's besides only <lf> at the end of lines uploading a csv file
using copy? I plan on loading the columns into text columns and converting them
as I load them to other tables.

The first two lines look like:
---------------------------------
ZIPCode,ZIPCodeType,City,CityType,County,CountyFIPS,State,StateCode,StateFIPS,MSA,AreaCode,TimeZone,GMTOffset,DST,Latitude,Longitude
00501,U,Holtsville,D,Suffolk,36103,New
York,NY,36,5380,631,Eastern,-5,Y,40.8147,-73.0451

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joseph Shraibman 2003-04-09 19:18:09 Re: constraint performance
Previous Message enediel 2003-04-09 18:28:01 Re: multiple fields index