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

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