Scott Marlowe wrote:
Csaba Nagy wrote:
On Thu, 2007-06-21 at 16:45, Scott Marlowe wrote:
Another option is to use your favorite scripting language and throw
an excel header then the data in tab delimited format. Or even in
excel xml format.
Why would you need any scripting language ? COPY supports CSV output
pretty well, it can even put you a header on the top.
Because I'm delivering reports to dozens of people who have windows, no
psql client, and just want to go to a web page, click a button, and get
their report (or was that a banana?)
If you make psql with the \H option output html, excel will open it
directly.
I guess I could give them an account on the reporting server and a copy
of pgadmin or something, but most of them are happier with a web page
and a set of buttons.
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
--
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
