Re: BUG #12721: psql -a does not preserve empty lines between SELECTs
| От | Tom Lane |
|---|---|
| Тема | Re: BUG #12721: psql -a does not preserve empty lines between SELECTs |
| Дата | |
| Msg-id | 18267.1422729300@sss.pgh.pa.us обсуждение исходный текст |
| Ответ на | BUG #12721: psql -a does not preserve empty lines between SELECTs (hans@matfyz.cz) |
| Ответы |
Re: BUG #12721: psql -a does not preserve empty lines between SELECTs
Re: BUG #12721: psql -a does not preserve empty lines between SELECTs |
| Список | pgsql-bugs |
hans@matfyz.cz writes:
> There is, in the [doc] that psql with option -a echoes all input lines.
Hm. That's poorly phrased: what it actually echoes is commands, not
lines. This must be so because some of the other possible settings of
ECHO require decisions at the per-command level. I will see about
improving the wording here.
> The empty line has disappeared. If there had been a comment line, it would
> have been preserved. Preserve also empty lines, please.
Sorry, that's not going to happen. psql has always stripped whitespace
appearing before a command, and changing that would create a lot of
unhappiness in a lot of other behaviors.
> PS: Please, is there a better way how to specify tab as delimiter?
Maybe put \pset fieldsep '\t' in the input .sql file, instead of setting
it up on the command line.
regards, tom lane
В списке pgsql-bugs по дате отправления: