From: | Boris Zentner <bzm(at)2bz(dot)de> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | psql removes dashed comments |
Date: | 2022-04-07 18:25:41 |
Message-ID: | DE9FE8CF-ABB4-4AA1-BCB5-B7F240374FFD@2bz.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2022-04-07 18:29:49 | Re: psql removes dashed comments |
Previous Message | Rob Sargent | 2022-04-07 18:12:56 | Re: Resources on modeling ordered hierachies? |