Create UNIQUE KEY

[pradheepayyanar]

hello
can anyone tell me how to create a table with 3 columns as UNIQUE KEY

PraDz

[somaskarthic]

hi

Try this

CREATE TABLE test1
(
id int4 NOT NULL,
field1 int4,
field2 int4,
field3 int4,
CONSTRAINT idpkey PRIMARY KEY (id),
CONSTRAINT field1unique1 UNIQUE (field1),
CONSTRAINT fieldunique2 UNIQUE (field2),
CONSTRAINT fieldunique3 UNIQUE (field3)
)


-somaskarthic

hello
can anyone tell me how to create a table with 3 columns as UNIQUE KEY

PraDz