Carlos Mennens <carlos.mennens@gmail.com> writes:
> Am I missing something here? When the command is on one line, auto
> complete works fine but when I break it up as show above in the 2nd
> example, it acts like 'COLUMN' isn't even a valid option but if I
> manually type the word 'COLUMN' and finish the command, it works.
Yeah, the autocompletion logic can only "see" the current line of input,
so in your second example it has no idea that this is an ALTER TABLE
command. My recollection is that there's no very nice way around that
given the limitations of the readline callback interface, though maybe
if somebody got ambitious they could improve it.
regards, tom lane
