Re: psql removes dashed comments
От | David G. Johnston |
---|---|
Тема | Re: psql removes dashed comments |
Дата | |
Msg-id | CAKFQuwbGpukHtXqSXRZQ7zRB+trmsOQok-=Y7JU=ERhcex4ySQ@mail.gmail.com обсуждение исходный текст |
Ответ на | psql removes dashed comments (Boris Zentner <bzm@2bz.de>) |
Список | pgsql-general |
On Thursday, April 7, 2022, Boris Zentner <bzm@2bz.de> wrote:
Hi,
I was wondering why psql loose dashed comments and what can be done about this misbehaviour.
# start psql, paste something run it, edit \e, rerun and so on. At the end all dashed comments are removed.
psql -Xe postgres
psql (14.1)
Type "help" for help.
postgres=# select 1, -- one
2, /* two */
3 -- three
;
select 1,
2, /* two */
3
;
?column? | ?column? | ?column?
----------+----------+----------
1 | 2 | 3
(1 row)
postgres=# \e
select 1,
2, /* two */
3
;
?column? | ?column? | ?column?
----------+----------+----------
1 | 2 | 3
(1 row)
My last comment seems a bit off, but all you’ve done here is demonstrate the documented behavior when the query buffer contains multiple commands when \e is executed.
In either case this is working as documented and you really should be using a permanent file for this kind of thing.
David J.
В списке pgsql-general по дате отправления: