Postgres Pro
Downloads
Home   >   mailing lists

Re: Using COPY - Mailing list pgsql-novice

From Tom Lane
Subject Re: Using COPY
Date
Msg-id 19456.1062522215@sss.pgh.pa.us
Whole thread Raw
In response to Using COPY  (Juan Francisco Diaz <j-diaz@publicar.com>)
Responses Re: Using COPY
List pgsql-novice
Tree view 
Juan Francisco Diaz <j-diaz@publicar.com> writes:
> The file was exported from mssqlserver2000 with ANSI coding, <cr> as row
> separator, no quotes for the texts, and TAB as the column separator.

Wrong thing :-(.  COPY will *only* accept <lf> as row separators.

This is relaxed for 7.4, but you're evidently not on 7.4 yet ...

            regards, tom lane

pgsql-novice by date:

Previous
From: Nabil Sayegh
Date:
Subject: Re: Using COPY
Next
From: Al Hulaton
Date:
Subject: Re: Can Postgresql run in MS Windows