Re: CSV mode option for pg_dump

Can't -- the main production database is over at a CoLo site with access
only available via SSH, and tightly-restricted SSH at that. Generally
one of the developers will SSH over to the server, pull out whatever
data is needed into a text file via psql or pg_dump, scp the file(s)
back here and send them to the user.

We're working on implementing a full-blown reporting system to eliminate
some of this need, but it's not quite there yet.

However, CSV is a very handy format to use to send data to other people
(especially "less technical" users), so even in the future the ability
to export to CSV would be handy.

- Bill

> -----Original Message-----
> From: Joshua D. Drake [mailto:jd(at)commandprompt(dot)com]
> Sent: Monday, June 12, 2006 4:15 PM
> To: Bill Bartlett
> Cc: 'Andrew Dunstan'; 'Tom Lane'; 'PG Hackers'
> Subject: Re: [HACKERS] CSV mode option for pg_dump
>
>
> Bill Bartlett wrote:
> > Here's me speaking up -- I'd definitely use it! As a
> quick way to pull
> > data into Excel to do basic reports or analysis, a CSV
> format would be
> > great.
>
> Why not just use ODBC?
>
> Joshua D. Drake
> --
>
> === 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/
>
>