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