Re: encoding confusion with \copy command

You are right that I need an intermediate step. I will probably use a CSV
parser that is liberal in what it accepts, but writes out strict CSV data
suitable for postgres.

Thanks for the help.

On 17 September 2014 15:40, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> wrote:

> On 09/17/2014 06:48 AM, Martin Waite wrote:
>
>> Hi Adrian,
>>
>> I apologise - I meant 9.4
>>
>
> Looks like you will need an intermediate step. A quick search found the
> below which might offer a solution:
>
> http://www.excel-sql-server.com/sql-server-export-to-
> excel-using-bcp-sqlcmd-csv.htm
>
> FYI the good stuff is at the bottom.
>
> There is also this SO answer that refers to SQL Server Management
> Studio(not sure if you have):
>
> http://stackoverflow.com/questions/6115054/how-to-get-
> export-output-in-real-csv-format-in-sql-server-managment-studio
>
>
>
>> regards,
>> Martin
>>
>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com
>