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 по дате отправления: