See:
http://www.postgresql.org/docs/current/static/sql-keywords-appendix.html
Try "UserName"
> -----Original Message-----
> From: pgsql-general-owner@postgresql.org
> [mailto:pgsql-general-owner@postgresql.org] On Behalf Of
> Thomas Mueller
> Sent: Wednesday, July 07, 2004 1:44 PM
> To: pgsql-general@postgresql.org
> Subject: [GENERAL] Column name 'user' not allowed?
>
>
> Hi,
>
> I tried to install phpopenchat but I can't create this table:
>
> poc=> CREATE TABLE poc_user_account (
> poc(> USER varchar(255) NOT NULL,
> poc(> PASSWORD varchar(255),
> poc(> CONFIRM_CODE char(32),
> poc(> DISABLED int NOT NULL DEFAULT '0',
> poc(> KICKED int NOT NULL DEFAULT '0',
> poc(> PASSWORD_NEW varchar(255),
> poc(> PRIMARY KEY (USER)
> poc(> );
> ERROR: syntax error at or near "USER" at character 35
>
> After searching a while what's wrong I renamed column USER to
> USER2 and now I can create the table! I don't see a reason
> why column name USER isn't allowed?!
>
> I am running Postgres 7.4.2 on Linux.
>
> Thanks!
>
>
> Thomas
> --
> http://www.tmueller.com for pgp key (95702B3B)
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>