Skip site navigation (1) Skip section navigation (2)

Create table error

From: Kumar S <ps_postgres(at)yahoo(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Create table error
Date: 2004-09-14 20:38:35
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
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_name        varchar(32)     not null,
        con_id          serial  references
        exp_type        varchar(32)     not null,
        exp_desc        varchar(64),
        exp_pmid        integer(30)     not null,
        exp_rawdata_url varchar(32),
        constraint      experiment_pk primary

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.

Please help. 


Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 


pgsql-novice by date

Next:From: Stephan SzaboDate: 2004-09-14 20:43:09
Subject: Re: Create table error
Previous:From: Betsy BarkerDate: 2004-09-14 16:24:37
Subject: Re: LockAcquire: lock table 1 is out of memory

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group