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)"
1
2
3
But my result is:
psql -At -P recordsep="\n\n" -U postgres -d chronopay -c "select
generate_series(1,3)"
1\n\n2\n\n3
Simple newline not work too:
psql -At -P recordsep="\n" -U postgres -d chronopay -c "select
generate_series(1,3)"
1\n2\n3
--------------
psql -At -P recordsep='\n\n' -U postgres -d chronopay -c "select
generate_series(1,3)"
psql -At -R '\n\n' -U postgres -d chronopay -c "select generate_series(1,3)"
psql -At -R "\n\n" -U postgres -d chronopay -c "select generate_series(1,3)"
no resultat
Is it a bug?
p.s. PostgreSQL 8.1.5 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC)
3.4.6 20060404 (Red Hat 3.4.6-3)
Thanks.