Peter Eisentraut <peter_e@gmx.net> writes:
> Is everyone okay with the following syntax:
> CREATE USER username
> [ WITH ID digits ]
> ^^^^^^^^^^^^^^^^^^
> The catch is that ID would have to be a new keyword and we'd have to live
> with that for a long time. Other choices include:
> * UID
> * SYSID
> * USESYSID
> etc.
I'd be inclined to go with UID or SYSID. In any case, since the new
keyword is used in such a limited context, we could almost certainly
still allow it as a ColId and thus not create any real compatibility
problem.
regards, tom lane