Doug McNaught wrote:
> Bruce Momjian <pgman@candle.pha.pa.us> writes:
>
> > > Shouldn't that be
> > >
> > > CREATE DATABASE dbname WITH OWNER = "user"
> > >
> > > ?
> >
> > Yes! OWNER is much better. TODO updated and I will save this message
> > for changes in 7.3:
>
> Will this make OWNER into a new keyword, and break schemas that have
> "owner" as a table or column name? USER is at least already a
> keyword...
We already use OWNER in ALTER TABLE so it is not really a new keyword:
| ALTER TABLE relation_name OWNER TO UserId
Also, its usage is limited to CREATE TABLE so I believe a column named
owner is still possible, as it is now.
-- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610)
853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill,
Pennsylvania19026