Re: Annoying messages when copy sql code to psql terminal

On Tue, May 27, 2008 at 03:24:38PM +0200, A B wrote:
> Whenever I use copy-paste to run code in a terminal window that is
> running psql, and the code contains a row like
>
> IF FOUND THEN
>
> then I get the words

 [...]

> That must be some kind of display of possible stuff to write after
> "THEN" but it is very annoying. How to turn it of?

I'd guess the next line of code starts with a tab character and hence
psql is just tab completing the (empty) line.  If you don't want this to
happen, you can disable table completion.  From the man page:

       If
       for some reason you do not like the tab completion, you can turn it off
       by putting this in a file named .inputrc in your home directory:

       $if psql
       set disable-completion on
       $endif

As an aside, there isn't an "if" statement in SQL.


  Sam