field separator problem

From: "Tena Sakai" <tsakai(at)gallo(dot)ucsf(dot)edu>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: field separator problem
Date: 2007-10-04 00:13:48
Message-ID: FE44E0D7EAD2ED4BB2165071DB8E328C03062CA8@egcrc-ex01.egcrc.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi Everybody,

I am having a problem with field separator. Maybe
someone can assist me.

But first thing firtst: I am running postgresql 8.2.4
on redhat, dell 64 bit machine:

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?

Regards,

Tena Sakai
tsakai(at)gallo(dot)ucsf(dot)edu

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Michael Fuhr 2007-10-04 00:54:10 Re: field separator problem
Previous Message Richard Broersma Jr 2007-10-03 17:07:25 Re: Need help with CASE statement in Function