From: Bruce Momjian <pgman@candle.pha.pa.us>
Message-Id: <200603200114.k2K1EtF29584@candle.pha.pa.us>
Subject: Re: Lead and tail quotes with \pset fieldsep
In-Reply-To: <200603201037.07638.dave.bath@unix.net>
To: dave.bath@unix.net
Date: Sun, 19 Mar 2006 20:14:55 -0500 (EST)
CC: pgsql-sql@postgresql.org
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Type: text/plain; charset=US-ASCII

Bath, David wrote:
> Folks
> 
> If I want psql to generate CSV files fully-double-quoted I can
> use pset as follows
> psql> \pset fieldsep ","
> However this does not put a quote before the first field and
> after the last, so each row comes out as
> 1234","blahblah","sdfgsg","foo","bar
> 
> Is there a way to use psql to give rows like
> 1234","blahblah","sdfgsg","foo","bar
> or is there another tool I should use.
> 
> COPY doesn't deal with views and restrictions well so it is
> not an option.

Just do:

	CREATE TEMP TABLE x AS SELECT * FROM view;
	COPY ... x

Sorry that is the only way to dump CVS properly.

-- 
  Bruce Momjian   http://candle.pha.pa.us
  SRA OSS, Inc.   http://www.sraoss.com

  + If your life is a hard drive, Christ can be your backup. +