Re: [BUGS] postgresql 8.1.5 psql -P recordsep='\n' not work

2007-04-02 Thread Peter Eisentraut
Am Montag, 2. April 2007 16:48 schrieb Denis Lishtovny: > I want to output result of query with double newline record separated. > > For example: > > psql -At -P recordsep="\n\n" -U postgres -c "select generate_series(1,3)" "\n" is not a newline, it's a "\" followed by an "n". You need to actuall

Re: [BUGS] postgresql 8.1.5 psql -P recordsep='\n' not work

2007-04-02 Thread Alvaro Herrera
Denis Lishtovny wrote: > Hello All. > > > > I want to output result of query with double newline record separated. > > For example: > > psql -At -P recordsep="\n\n" -U postgres -c "select generate_series(1,3)" What this says is that there's no interpolation of escapes in recordsep. Try putt