On Thu, 26 Mar 2009 08:04:25 +0100 Pavel Stehule <pavel.steh...@gmail.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 -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
