Re: field separator problem - Mailing list pgsql-sql

From Michael Fuhr
Subject Re: field separator problem
Date
Msg-id 20071004005409.GA65942@winnie.fuhr.org
Whole thread Raw
In response to field separator problem  ("Tena Sakai" <tsakai@gallo.ucsf.edu>)
List pgsql-sql
On Wed, Oct 03, 2007 at 05:13:48PM -0700, Tena Sakai wrote:
> I issue from psql \f (or "\pset fieldsep ','") and
> psql appears to accept what I want:
> 
>   canon=# \f ','
>   Field separator is ",".
> 
> canon is the name of database, but when I issue a select
> command, it still uses '|' as separator.  What am I
> doing wront?

fieldsep applies only to unaligned mode (\a or \pset format unaligned).

-- 
Michael Fuhr


pgsql-sql by date:

Previous
From: Jeff Frost
Date:
Subject: Why does the sequence skip a number with generate_series?
Next
From: Stephan Szabo
Date:
Subject: Re: Why does the sequence skip a number with generate_series?