psql removes dashed comments
От | Boris Zentner |
---|---|
Тема | psql removes dashed comments |
Дата | |
Msg-id | DE9FE8CF-ABB4-4AA1-BCB5-B7F240374FFD@2bz.de обсуждение исходный текст |
Ответы |
Re: psql removes dashed comments
Re: psql removes dashed comments Re: psql removes dashed comments |
Список | pgsql-general |
Hi, I was wondering why psql loose dashed comments and what can be done about this misbehaviour. I get often some sql, paste it into psql run and edit it via \e. A few iterations until everything works. But psql removes the comments and creates a lot extra work to restore the comments and changes to the query. Here is an example: # 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) -- Boris
В списке pgsql-general по дате отправления: