Re: [despammed] Select dump

From: John DeSoi <desoi(at)pgedit(dot)com>
To: PostgreSQL Novice <pgsql-novice(at)postgresql(dot)org>
Cc: SG Edwards <s0460205(at)sms(dot)ed(dot)ac(dot)uk>
Subject: Re: [despammed] Select dump
Date: 2005-05-11 13:49:14
Message-ID: 764CAFC6-C223-11D9-B6B5-000A95B03262@pgedit.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice


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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Van Ingen, Lane 2005-05-11 13:53:50 First plpgsql Script
Previous Message Andreas Kretschmer 2005-05-11 13:34:32 Re: [despammed] Select dump