2009/3/26 Josh Trutwin <j...@trutwins.homeip.net>: > 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. >
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@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-sql > -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
