Re: encoding confusion with \copy command

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Martin Waite <waite(dot)134(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: encoding confusion with \copy command
Date: 2014-09-17 14:40:49
Message-ID: 54199D71.9030608@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dev Kumkar 2014-09-17 14:53:34 Re: Regarding timezone
Previous Message Adrian Klaver 2014-09-17 13:54:53 Re: Regarding timezone