Re: can't create user collumn

On 3/17/06, loki <loigu(at)centrum(dot)cz> wrote:
> Hi,
> i'm just starting with postgres DB, but this looks very strange to me:
>
> If i try to create table with collumn user, it fails with error:
> create exec error:ERROR: syntax error at or near "user" at character 368
>
> query:
> CREATE TABLE Log (
> log_date date NOT NULL,
> log_time time NOT NULL,
> timezone int NOT NULL default 60 ,
> dest varchar(20) NOT NULL default 'messages',
> hostname varchar(100) NOT NULL default 'localhost',
> source varchar(20) NOT NULL default 'db_speed',
> pid numeric(10) NOT NULL default 0 ,
> category int NOT NULL default 10 ,
> priority int NOT NULL default 10 ,
> user int NOT NULL default 0 ,
> log varchar(800) NOT NULL
> );
>
> But if I change the collumn name to "usr" (just this, nothing else), it
> is o.k. and the table is created.

user is a reserved sql word:

http://www.postgresql.org/docs/8.1/static/sql-keywords-appendix.html

--
Postgresql & php tutorials
http://www.designmagick.com/