Re: CREATE TABLE oddity?

From: Jochem van Dieten <jochemd(at)oli(dot)tudelft(dot)nl>
To: "Nigel J(dot) Andrews" <nandrews(at)investsystems(dot)co(dot)uk>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: CREATE TABLE oddity?
Date: 2002-10-31 13:59:58
Message-ID: 3DC1375E.9080600@oli.tudelft.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Nigel J. Andrews wrote:

>
> I must be missing something but I don't know what and I can't see
> anything in the create table documentation (from 7.2.1) mentioning this.
>
> When I do, in psql:
>
> -- in this I have tried atype as int, serial and varchar
> CREATE TABLE user (
> something atype
> );
>
> I get the following response:
>
> ERROR: parser: parse error at or near "user"
>
> It is down to the table name I'm trying to use but I don't see why
> it's disallowed. Is user a special reserved word in the parser?

http://www.postgresql.org/idocs/index.php?sql-keywords-appendix.html

Jochem

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Nigel J. Andrews 2002-10-31 14:10:25 Re: CREATE TABLE oddity?
Previous Message Nigel J. Andrews 2002-10-31 13:54:56 CREATE TABLE oddity?