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.
Josh