Re: [GENERAL] issue with delimiter in field during COPY

On Monday, November 14, 2011 6:27:10 am LPlateAndy wrote: > Thanks Adrian, > > > > Apologies, i'd assumed specifying "CSV" would work just for actual CSV > files with comma separation. No problem. CSV has become a generic term describing separated value files of all types. > > > > Thanks

Re: [GENERAL] issue with delimiter in field during COPY

Thanks Adrian, Apologies, i'd assumed specifying "CSV" would work just for actual CSV files with comma separation. Thanks again Andy From: Adrian Klaver-3 [via PostgreSQL] [mailto:ml-node+s1045698n4990887...@n5.nabble.com] Sent: 14 November 2011 14:24 To: LPlateAndy Subject: Re: is

Re: [GENERAL] issue with delimiter in field during COPY

On Monday, November 14, 2011 5:39:41 am LPlateAndy wrote: > Hi, > > Using COPY to bring data into a table. It uses "|" which i allow for with a > command such as: > > COPY mydata FROM E'C:\\mydata\\mydata.txt' USING DELIMITERS '|' > > This works fine except for a url field which randomly include

Re: [GENERAL] issue with delimiter in field during COPY

Hi, My apologies for the previous post, i reread the documentation and realised that a "CSV" load can actually use a file with delimiters other than a comma. As such, i have answered my own question. Thanks Andy -- View this message in context: http://postgresql.1045698.n5.nabble.com/issue-wi