From: | Ennio-Sr <nasr(dot)laili(at)tin(dot)it> |
---|---|
To: | Kumar S <ps_postgres(at)yahoo(dot)com> |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: Create table error |
Date: | 2004-09-14 21:19:40 |
Message-ID: | 20040914211939.GA11168@deby.ei.hnet |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
* Kumar S <ps_postgres(at)yahoo(dot)com> [140904, 13:38]:
> Dear group,
> Could you please suggest if my sql syntax is wrong for
> creating the table:
> my sql statements:
> create table EXPERIMENT
> (
> exp_id serial,
> [ ... ]
> exp_rawdata_url varchar(32),
^^^
> constraint experiment_pk primary
> key(exp_id)
> );
>
>
> When I compile this I get the following error:
> psql:/home/sk/temp/postgres/exp.sql:11: ERROR: syntax
> error at or near "(" at character 200
>
> What is wrong with my code.
May be you should drop the underlined comma?
Regards,
Ennio.
--
[Perche' usare Win$ozz (dico io) se ..."anche uno sciocco sa farlo. \\?//
Fa' qualche cosa di cui non sei capace!" (diceva Henry Miller) ] (°|°)
[Why to use Win$ozz (I say) if ... "even a fool can do that. )=(
Do something you aren't good at!" (used to say Henry Miller) ]
From | Date | Subject | |
---|---|---|---|
Next Message | Kumar S | 2004-09-14 21:39:28 | Re: Create table error |
Previous Message | Stephan Szabo | 2004-09-14 20:43:09 | Re: Create table error |