Re: creating "user" table

Hey,

> > Chris> Hi,
> > Chris> This one is more for the developers, but other
>comments welcome.
> >
> > Chris> Since we can't create a table called user in a
>normal database due to
> > Chris> the reserved keyword problem,
> >
> > False precondition!
> >
> > template1=# create database demo;
> > CREATE DATABASE
> > template1=# \c demo
> > You are now connected to database demo.
> > demo=# create table "user" (name text, age int);
> > CREATE
> > demo=# \d
> > List of relations
> > Name | Type | Owner
> > ------+-------+--------
> > user | table | merlyn
> > (1 row)
> >
> > demo=# \d user
> > Table "user"
> > Attribute | Type | Modifier
> > -----------+---------+----------
> > name | text |
> > age | integer |
> >
> > demo=# insert into "user" values ('Randal', 39);
> > INSERT 1034607 1
> > demo=# insert into "user" values ('Russ', 38);
> > INSERT 1034608 1
> > demo=# insert into "user" values ('Ron', 35);
> > INSERT 1034609 1
> > demo=# select * from "user" order by age;
> > name | age
> > --------+-----
> > Ron | 35
> > Russ | 38
> > Randal | 39
> > (3 rows)
> >
> > demo=#
> >
> > You can quote any reserved word to get any name you want.
> > You just need to think of the table name of demo as
>_ "demo" _.
> >

True, didn't give that example, but.. try that in another DBMS :) I know
(at least) MySQL won't let you do that (*waits for the obvious comment*),
don't know about other DBMS needing quotes around the name, but I don't
think that one is portable to other systems :/

As Jochem pointed out in another post, by definition it's a reserved word
(both sql92 & 99) so I'll go back to my corner again :)

-----------------
Chris Smith
http://www.squiz.net/