The syntax for creating tables with compound primary keys is a bit different from the single-column primary key syntax we saw in the previous chapter. We create a user_status_updates table with a compound primary key, as follows:
CREATE TABLE "user_status_updates" ( "username" text, "id" timeuuid, "body" text, PRIMARY KEY ("username", "id") );
In particular, instead of appending a single-column definition with a PRIMARY KEY modifier, we make a separate PRIMARY KEY declaration at the end of the list of columns, which itself specifies the two columns that make up the compound primary key.
While this is the only way to declare a compound primary key, it's also a perfectly valid way to declare ...
