Re: CREATE TABLE oddity? - Mailing list 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