Re: creating "user" table - Mailing list pgsql-general

From Chris
Subject Re: creating "user" table
Date
Msg-id 4.3.2.7.2.20010923104329.00acd580@pop.iprimus.com.au
Whole thread Raw
In response to creating "user" table  (Chris <tomcat@weirdness.com>)
Responses Re: creating "user" table
List pgsql-general
> > Hi,
> >
> > This one is more for the developers, but other comments welcome.
> >
> > Since we can't create a table called user in a normal database due to
> > the reserved keyword problem, would it be easy or worthwhile just having
> > the CREATE USER information in the template1 database?
>
>Uhhh, what "CREATE USER information"?
Sorry, thought I was clear.
I meant only be able to create users when you're connected to the template1 db.

so
test=# create user x;

wouldn't work, since you're not using template1.

that way the user keyword would be free to use as a table name.

Chris.


pgsql-general by date:

Previous
From: "Gurunandan R. Bhat"
Date:
Subject: Problem while logging primary key of updated field.
Next
From: Peter Eisentraut
Date:
Subject: Re: creating "user" table