CODEWITHSUNDEEP
databasepostgresqlprimary-key
Léo Léopold Hertz 준영
Léo Léopold Hertz 준영

Reputation: 141340

To show correctly PRIMARY KEY in Postgres

Which one of the following ways would you use in declaring Primary Keys by Postgres?

#1

CREATE TABLE user(
    user_id PRIMARY KEY,
    ...
)

#2

CREATE TABLE user(
    user_id NOT NULL,
    ...
    CONSTRAINT user_pk PRIMARY KEY(user_id);
)

Upvotes: 0

Views: 465

Answers (1)

Greg Hewgill
Greg Hewgill

Reputation: 994231

I would use method #1.

  • The indication of which column is the primary key is kept closer to the actual column definition
  • You don't have to think up a name for the constraint; a name will be automatically generated

One reason to use method #2 is if your primary key were to span more than one column. In that case, method #1 won't work because it only supports a single column primary key.

Upvotes: 1

Related Questions