Problem setting FIELDSEP variable

[billykopecki]

Hi guys,

For some reason I can't get the filed separator to work. I'm using 6.1.

Code: Select all

dbadmin=> \pset fieldsep ','
Field separator is ",".
dbadmin=> select * from x;
   y   |   z
-------+-------
 data1 | data2
 data3 | data3
(2 rows)

Code: Select all

dbadmin=> \pset tuples_only
Showing only tuples.
dbadmin=> select * from x;
 data1 | data2
 data3 | data3

I expected to get this result set:

Code: Select all

dbadmin=> select * from x;
data1,data2
data3,data3

Thanks.

[sarah]

Billy,

You also need to use th the \a meta-command which will change the alignment.

Code: Select all

dbadmin=> \a
Output format is unaligned.

[billykopecki]

Thanks, Sarah! That did the trick

Code: Select all

dbadmin=> \a
Output format is unaligned.
dbadmin=> \t
Showing only tuples.
dbadmin=> \pset fieldsep ','
Field separator is ",".
dbadmin=> select * from x;
data1,data2
data3,data3