Hi,
When used PostgreSQL 9.6.* it was common use in psql \r\e to clear a buffer
query and open the empty text editor. Works fine for me and it was very
useful in my tasks.
Since PostgreSQL 10, this behavior changed and not more clear the
buffer query.
psql helps show that \r reset (clear) the query buffer but in practice
don't work or I do not understand how would work.
Example using postgrsql 11.8 :
select 1;
\e
-> Open temp file with a last statement "select 1;"
exit text editor and run command. It's ok.
\r
\e
-> Open temp file with the same last command "select 1;"
is it right?
--
*Regards,Emanuel Araújo*