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 putting them literally: $ psql -At -P recordsep=" > > " -c "select generate_series(1,3)" 1 2 3 -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
