BUG #12721: psql -a does not preserve empty lines between SELECTs

From: hans(at)matfyz(dot)cz
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #12721: psql -a does not preserve empty lines between SELECTs
Date: 2015-01-31 17:37:38
Message-ID: 20150131173738.2581.57661@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 12721
Logged by: Hans Ginzel
Email address: hans(at)matfyz(dot)cz
PostgreSQL version: 9.4.0
Operating system: GNU/Linux Centos 6.5
Description:

Hello!

There is, in the [doc] that psql with option -a echoes all input lines.

Try a file containing
SELECT count(*) AS N FROM information_schema.Tables;

SELECT count(*) AS N FROM information_schema.Columns;

There is an empty line between SELECTs and they are each on one line. The
output of
cat input.sql |psql -naAF"`echo -e '\t'`" -Pfooter=off
is in my case is

SELECT count(*) AS N FROM information_schema.Tables;
n
205
SELECT count(*) AS N FROM information_schema.Columns;
n
1855

The empty line has disappeared. If there had been a comment line, it would
have been preserved. Preserve also empty lines, please.

[doc]: http://www.postgresql.org/docs/9.4/static/app-psql.html

Best regards
HG

PS: Please, is there a better way how to specify tab as delimiter?

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2015-01-31 18:35:00 Re: BUG #12721: psql -a does not preserve empty lines between SELECTs
Previous Message Peter Geoghegan 2015-01-31 00:41:15 Re: BUG #12718: Apparent LWlock Problem Perhaps With Page Cleanup