Re: Two successive tabs in test case are causing syntax error in psql

On 2022-Jul-08, Tom Lane wrote:

> The usual recommendation for pasting text into psql when it contains
> tabs is to start psql with the -n switch to disable tab completion.

"Bracketed paste" also solves this problem. To enable this feature,
just edit your $HOME/.inputrc file to have the line
set enable-bracketed-paste on
(then restart psql) which will cause the text passed to be used
literally, so the tabs won't invoke tab-completion. There are other
side-effects: if you paste a multi-command string, the whole string is
added as a single entry in the history rather than being separate
entries. I find this extremely useful; there are also claims of this
being more secure.

--
Álvaro Herrera Breisgau, Deutschland — https://www.EnterpriseDB.com/