On May 11, 2005, at 9:34 AM, Andreas Kretschmer wrote:
> If you work with psql, you can use "\o FILE" to define a filename for
> output. If you work in a shell a call psql, you can redirect the
> output.
And see the psql documentation for the other options you need. You'll
want to set the field separator to a comma and turn on the "tuples
only" option to get rid of the headers and other information normally
in the output.
http://www.postgresql.org/docs/current/interactive/app-psql.html
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL