Mark Hollomon (mhh(at)mindspring(dot)com) reports a bug with a severity of 3
The lower the number the more severe it is.
Short Description
psql -P doesn't honor backslash escapes
Long Description
The interactive command psql command:
\pset fieldsep '\t'
can be used to set the field separator to a tab character.
The equivalent commandline option:
psql -P fieldsep='\t'
sets it to the literal '\t'
Sample Code
$ ~/pgsql/bin/psql -P format=u -P fieldsep='\t' -P tuples_only -c 'select * from flag_stats order by date' metrics
2000-10-05 10:06:58-04\t18\t13\t13\t4
2000-10-05 10:26:53-04\t19\t14\t14\t5
2000-10-05 10:46:33-04\t19\t13\t13\t5
No file was uploaded with this report