psql removes dashed comments

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

Responses

Browse pgsql-general by date

  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?