Re: Table to Excel

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: Nicholas I <nicholas(dot)domnic(dot)i(at)gmail(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Table to Excel
Date: 2009-03-26 07:04:25
Message-ID: 162867790903260004u4938ed45j9e5dd0051f700b92@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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 <nicholas(dot)domnic(dot)i(at)gmail(dot)com>:
> 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
>

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Albe Laurenz 2009-03-26 09:44:34 Re: [ADMIN] Can we load all database objects in memory?
Previous Message Nicholas I 2009-03-26 06:35:23 Table to Excel