Re: [HACKERS] Re: [SQL] SQL-Query 2 get primary key

> > if I create a table like this:
> > CREATE TABLE test (
> > id decimal(3) primary key,
> > name varchar(32));
<snip>
> Note that this makes the assumption that only one field can be in the
> primary key (no complex primary keys) but I don't think there will
> ever be more than one the way we declare it now.

fyi, the following syntax is allowed:

CREATE TABLE test (
id decimal(3),
name varchar(32),
primary key(id));

and multiple columns can be declared as primary keys.

- Tom