PostgreSQL CREATE TABLE error

Question

I'm new in PostgreSQL. I try to create table in database. In psql i write:

CREATE TABLE mail_user (
   user char(50) NOT NULL,
   domain char(50) NOT NULL,
   password char(50) NOT NULL
);

But i get error:

ERROR: syntax error at or near "user" LINE 2: user char(50) NOT NULL, ^

What's wrong? How can i fix it?

Thank you.

Derek Arnold · Answer 1 · 2011-02-27 16:57:02Z

up vote 2 down vote accepted

You can use reserved words by quoting them:

CREATE TABLE mail_user (
   "user" char(50) NOT NULL,
   domain char(50) NOT NULL,
   password char(50) NOT NULL
);

answered Feb 27 at 16:57

And don't forget to use quotes in every query you execute on this table, "user" will always be a reserved word. – Frank Heikens Feb 28 at 8:58

feedback

Eric Humphrey - lotsahelp · Answer 2 · 2011-02-27 16:46:39Z

up vote 3 down vote

answered Feb 27 at 16:46

feedback

2 Answers