-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
> After the "TO" there is one space and the cursor is after that space > I press tab and I get > > leda=# ALTER TABLE any_table RENAME TO TO What is happening is that psql is simply assuming that the first "TO" may be the name of a column you are about to rename. It's the same as: ALTER TABLE any_table RENAME mycolumn TO We can probably have the tab-completion code call up a list of column names for comparison: not sure if is worth the trouble though. - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200504101714 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -----BEGIN PGP SIGNATURE----- iD8DBQFCWZc7vJuQZxSWSsgRAoPiAKCVQHa2swRy6/jGzKGJplVv7je1mACg2Z6J hJ8eSYiss3LDHsBQLBWrBJc= =jjYQ -----END PGP SIGNATURE----- ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])