<p><font size="2">many thanks, Michael! I appreciate it.<br /><br /> Regards,<br /><br /> Tena<br /><br /><br />
-----OriginalMessage-----<br /> From: Michael Fuhr [<a href="mailto:mike@fuhr.org">mailto:mike@fuhr.org</a>]<br />
Sent:Wed 10/3/2007 5:54 PM<br /> To: Tena Sakai<br /> Cc: pgsql-sql@postgresql.org<br /> Subject: Re: [SQL] field
separatorproblem<br /><br /> On Wed, Oct 03, 2007 at 05:13:48PM -0700, Tena Sakai wrote:<br /> > I issue from psql
\f(or "\pset fieldsep ','") and<br /> > psql appears to accept what I want:<br /> ><br /> > canon=# \f
','<br/> > Field separator is ",".<br /> ><br /> > canon is the name of database, but when I issue a
select<br/> > command, it still uses '|' as separator. What am I<br /> > doing wront?<br /><br /> fieldsep
appliesonly to unaligned mode (\a or \pset format unaligned).<br /><br /> --<br /> Michael Fuhr<br /><br /></font>