From: | Greenhorn <user(dot)postgresql(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-27 16:27:37 |
Message-ID: | ddcb1c340903270927if72fcf9je211e30156378db6@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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
>
I find it easier to use the ODBC Driver (available at
http://pgfoundry.org/projects/psqlodbc/) and query the database from
Excel. This way you get updateable results (right click refresh data)
with the option of modifying your query from within Excel.
--
THINK BEFORE YOU PRINT - Save paper if you don't really need to print this.
From | Date | Subject | |
---|---|---|---|
Next Message | Jasen Betts | 2009-03-28 11:57:00 | Re: Table to Excel |
Previous Message | Dominik Piekarski | 2009-03-27 12:10:50 | Add: Special sort querstion |