Re: creating "user" table

From: Daniel ?erud <zilch(at)home(dot)se>
To: merlyn(at)stonehenge(dot)com, tomcat(at)weirdness(dot)com, pgsql-general(at)postgresql(dot)org
Subject: Re: creating "user" table
Date: 2001-09-23 17:02:22
Message-ID: 1001264542.304zilch@home.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Thanks for the information !!

delyx.

Daniel Åkerud.

> >>>>> "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!
>
> ---------------------------(end of broadcast)-------------
--------------
> TIP 3: if posting/reading through Usenet, please send an
appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so
that your
> message can get through to the mailing list cleanly
>

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Keary Suska 2001-09-23 20:09:57 Re: Where are Perl DBI and DBD for PostgreSQL??
Previous Message Pat M 2001-09-23 16:29:38 Re: My brain hurts - update field based on value of another table's field