Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group