psql -P doesn't honor backslash escapes - Mailing list pgsql-bugs

From pgsql-bugs@postgresql.org
Subject psql -P doesn't honor backslash escapes
Date
Msg-id 200010061318.e96DIsd06536@hub.org
Whole thread Raw
Responses Re: psql -P doesn't honor backslash escapes
List pgsql-bugs
Mark Hollomon (mhh@mindspring.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

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: PostgreSQL 7.0 beta 4: Error in Insert/Select
Next
From: Peter Eisentraut
Date:
Subject: Re: psql -P doesn't honor backslash escapes