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

From: "Denis Lishtovny" <d(dot)lishtovny(at)chronopay(dot)com>
To: <pgsql-bugs(at)postgresql(dot)org>
Subject: postgresql 8.1.5 psql -P recordsep='\n' not work
Date: 2007-04-02 14:48:36
Message-ID: 20070402144653.69F2B9FB71A@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Alvaro Herrera 2007-04-02 15:16:13 Re: postgresql 8.1.5 psql -P recordsep='\n' not work
Previous Message Zubkovsky, Sergey 2007-04-02 09:16:00 Re: ERROR: tuple concurrently updated