While testing a patch I fat-fingered a CREATE DATABASE statement by tab completing *after* the semicolon, with no space between the objname and semicolon. The below options were presented, which at this point aren't really applicable:
db=# create database foo; ALLOW_CONNECTIONS ENCODING LC_COLLATE LOCALE TABLESPACE CONNECTION LIMIT IS_TEMPLATE LC_CTYPE OWNER TEMPLATE DROP DATABASE has a similar tab completion which makes about as much sense: db=# drop database foo;WITH ( Checking prev_wd for not ending with ';' as per the attached makes "objname;" behave like "objname ;". Is there a reason for not doing that which I'm missing? I didn't check for others, but if this seems reasonable I'll go through to find any other similar cases. -- Daniel Gustafsson https://vmware.com/
psql_createdb-tabcomplete.diff
Description: Binary data