CODEWITHSUNDEEP
sqlamazon-redshift
Santanu C
Santanu C

Reputation: 1392

Redshift : defining composite primary key

I have a table for which I want to define a composite primary key with two columns in redshift. I am having some trouble with create table syntax. Here is what I am trying to do :

Create table metrics  (
     id varchar(30),
     runtime timestamp,
     category varchar(30),
     location varchar(30))
primary key(id, runtime),
sortkey(runtime);

It is failing with a message : 

ERROR:  syntax error at or near "PRIMARY"

Can anyone please help me figure out how to fix it? Thanks in advance.

Upvotes: 11

Views: 20446

Answers (1)

Gordon Linoff
Gordon Linoff

Reputation: 1269553

The primary key constraint goes inside the parentheses containing the columns:

Create table metrics  (
     id varchar(30),
     runtime timestamp,
     category varchar(30),
     location varchar(30),
     primary key(id, runtime)
)
sortkey(runtime);

Upvotes: 24

Related Questions