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 actually enter two newlines psql -At -P recordsep=" " -U postgres -c "select generate_series(1,3)" or figure out how your shell makes escapes available. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
