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
Code: Select all
dbadmin=> select * from x;
data1,data2
data3,data3