Re: creating "user" table

>>>>> "Chris" == Chris <tomcat(at)weirdness(dot)com> writes:

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" _.

--
Randal L. Schwartz - Stonehenge Consulting Services, Inc. - +1 503 777 0095
<merlyn(at)stonehenge(dot)com> <URL:http://www.stonehenge.com/merlyn/>
Perl/Unix/security consulting, Technical writing, Comedy, etc. etc.
See PerlTraining.Stonehenge.com for onsite and open-enrollment Perl training!