Field Separator setting not used.
Kevin Colagio (kevin.colagio@usa.xerox.com) reports a bug with a severity of 2
The lower the number the more severe it is.
Short Description
Field Separator setting not used.
Long Description
(This is major because I have about 20 scripts that I would have to modify to get this to work...and I don't think I am the only one who uses this functionality.)
I have scripts that call the following:
psql -t -q -d servicedesk -F '###' -c "select * from users"
The output should be along the lines of:
abc123###Kevin###Colagio###820###209###x56469
Which is then parsed by a perl program...but instead, it comes up as:
abc123 | Kevin | Colagio | 820 | 209 | x56469
I have also tried:
psql servicedesk
\pset fieldsep ###
And that doesn't work either. It responds as if it accepts it, but doesn't use it when printing out.
The OS is Solaris 2.8 and the version of PostgreSql is 7.0.2 .
Anything else I can help with, let me know.
Thanks.
Sample Code
No file was uploaded with this report
pgsql-bugs@postgresql.org writes:
psql -t -q -d servicedesk -F '###' -c "select * from users"
The output should be along the lines of:
abc123###Kevin###Colagio###820###209###x56469
Which is then parsed by a perl program...but instead, it comes up as:
abc123 | Kevin | Colagio | 820 | 209 | x56469
You need to set the output mode to unaligned, e.g., using the -A option.
Quoth the documentation:
\pset parameter [ value ]
...
format Sets the output format to one of unaligned,
aligned, html, or latex. Unique abbrevia�
tions are allowed. (That would mean one let�
ter is enough.)
``Unaligned'' writes all fields of a tuple
on a line, separated by the currently active
field separator. This is intended to create
output that might be intended to be read in
by other programs (tab-separated, comma-sep�
arated).
...
fieldsep
Specifies the field separator to be used in
unaligned output mode. That way one can cre�
ate, for example, tab- or comma-separated
output, which other programs might prefer.
--
Peter Eisentraut peter_e@gmx.net http://yi.org/peter-e/