BUG #12721: psql -a does not preserve empty lines between SELECTs
От | hans@matfyz.cz |
---|---|
Тема | BUG #12721: psql -a does not preserve empty lines between SELECTs |
Дата | |
Msg-id | 20150131173738.2581.57661@wrigleys.postgresql.org обсуждение исходный текст |
Ответы |
Re: BUG #12721: psql -a does not preserve empty lines between SELECTs
|
Список | pgsql-bugs |
The following bug has been logged on the website: Bug reference: 12721 Logged by: Hans Ginzel Email address: hans@matfyz.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?
В списке pgsql-bugs по дате отправления: