csv files - Mailing list pgsql-general

From Dennis Gearon
Subject csv files
Date
Msg-id 3E9467D1.8040504@cvc.net
Whole thread Raw
Responses Re: csv files  (Bruno Wolff III <bruno@wolff.to>)
List 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


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Error: heap_mark4update: (am)invalid tid
Next
From: Joseph Shraibman
Date:
Subject: Re: constraint performance