Re: Table to Excel

2009/3/26 Josh Trutwin <josh(at)trutwins(dot)homeip(dot)net>:
> On Thu, 26 Mar 2009 08:04:25 +0100
> Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> 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:
>
> \o myresults.html
>
> Then run a single query:
>
> SELECT col1, col2 FROM foo WHERE bar = '1' ORDER BY baz;
>
> \q
>
> Now you can open your .html file directly into Excel since it's just
> a big html table.
>

It is true, so you can use html, but html has significant overhead -
CVS is really simple format - designed for this case.

Pavel

> Josh
>
> --
> Sent via pgsql-sql mailing list (pgsql-sql(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-sql
>