On 2009-03-26, Nicholas I wrote:
> --002215046d3b27679c0465ffd2cf
> Content-Type: text/plain; charset=ISO-8859-1
> Content-Transfer-Encoding: 7bit
>
> Hi ,
>
> Does any one how to convert table to excel.
>
> I just tried the COPY table_name to '/home/user/output.xls' using
> delimiters ',';
use
2009/3/26 Nicholas I :
> Hi ,
>
> Does any one how to convert table to excel.
>
> I just tried the COPY table_name to '/home/user/output.xls' using
> delimiters ',';
>
> but the out put of the table that is the column in a table are tab separted,
> all were merged in a single cell.
>
> -Nicholas
2009/3/26 Josh Trutwin :
> On Thu, 26 Mar 2009 08:04:25 +0100
> Pavel Stehule wrote:
>
>> hello
>>
>> use csv format - excel have to read this format without any format
>>
>> COPY tablename TO '...' CSV;
>
> Another possibility that I use often is to set the output to HTML
> mode using:
>
> \H
>
>
On Thu, 26 Mar 2009 08:04:25 +0100
Pavel Stehule wrote:
> hello
>
> use csv format - excel have to read this format without any format
>
> COPY tablename TO '...' CSV;
Another possibility that I use often is to set the output to HTML
mode using:
\H
Then set to send query results to a file:
hello
use csv format - excel have to read this format without any format
COPY tablename TO '...' CSV;
regards
Pavel Stehule
2009/3/26 Nicholas I :
> Hi ,
>
> Does any one how to convert table to excel.
>
> I just tried the COPY table_name to '/home/user/output.xls' using
> delimiters ',';
>
>
Hi ,
Does any one how to convert table to excel.
I just tried the COPY table_name to '/home/user/output.xls' using
delimiters ',';
but the out put of the table that is the column in a table are tab separted,
all were merged in a single cell.
-Nicholas I
