How do I create a composite key?

I know how to do this in the UI, but how can I do this in SQL?

create table "userWantList" (
  userId uuid references "userData" (id) primary key,
  "createdAt" timestamp default now(),
  "collectibleId" character not null primary key,
  "collectibleType" bigint references "collectibleTypes" (id)
);


Gives me the error multiple primary keys for table "userWantList" are not allowed
Was this page helpful?