Thread: field separator problem
<p><font size="2">Hi Everybody,<br /><br /> I am having a problem with field separator. Maybe<br /> someone can assist me.<br/><br /> But first thing firtst: I am running postgresql 8.2.4<br /> on redhat, dell 64 bit machine:<br /><br /> Iissue 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, itstill uses '|' as separator. What am I<br /> doing wront?<br /><br /> Regards,<br /><br /> Tena Sakai<br /> tsakai@gallo.ucsf.edu<br/><br /><br /></font>
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
<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>