Re: psql removes dashed comments

On Thursday, April 7, 2022, Boris Zentner <bzm(at)2bz(dot)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.