pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Steve Crawford <scrawford@pinpointresearch.com>
To: David Durham <ddurham@vailsys.com>
To: pgsql-admin@postgresql.org
Subject: Re: dumping query results to a csv
Date: Thu, 25 Aug 2005 16:55:55 -0700
Message-ID: <200508251655.55679.scrawford@pinpointresearch.com> (raw)
In-Reply-To: <430E4536.3030203@vailsys.com>
References: <430E4536.3030203@vailsys.com>

On Thursday 25 August 2005 3:24 pm, David Durham wrote:
> This is kind of a pg-admin newbie question, so apologies in
> advance.
>
> Anyway, I'd like to issue a command that dumps the results of a
> query to a txt file in comma delimited format.  Does PostgreSQL
> ship with something to do this?  I searched the web, but found what
> appeared to be non-free solutions.

Use heredoc notation to set the format to unaligned, set your field 
separator (and, if necessary, record separator) to whatever you want, 
turn off the footer, and run the output to a file:

psql <any needed connection parameters> --quiet databasename <<EOT
\pset format unaligned
\pset fieldsep ','
\pset footer
\o youroutputfile.csv
select ......
EOT

Or if you prefer everything on the command line:
psql <any needed connection parameters> --quiet --no-align 
--field-separator ',' --pset footer --output youroutputfile.csv 
--command <select .......> databasename

Optionally add \pset tuples-only (first example) or --tuples-only 
(second example) if you do not want the header line with field names 
to be included. Note, if you use tuples only, you don't need to turn 
off the footer separately. You can also use the short versions of all 
the command line switches if you prefer. "man psql"

Cheers,
Steve




view thread (8+ messages)  latest in thread

Message-ID: <200508251655.55679.scrawford@pinpointresearch.com>
Permalink:  ../200508251655.55679.scrawford@pinpointresearch.com/
Also on:    postgresql.org/message-id/200508251655.55679.scrawford@pinpointresearch.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: scrawford@pinpointresearch.com, ddurham@vailsys.com
  Subject: Re: dumping query results to a csv
  In-Reply-To: <200508251655.55679.scrawford@pinpointresearch.com>
  References: <430E4536.3030203@vailsys.com> <200508251655.55679.scrawford@pinpointresearch.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox