PostgreSQL/Constraints/Add Primary Key
Add primary key in table create statement
<source lang="sql">
postgres=# postgres=# postgres=# CREATE TABLE "states" ( postgres(# "id" integer NOT NULL, postgres(# "name" text, postgres(# "abbreviation" character(2), postgres(# Constraint "state_pkey" Primary Key ("id") postgres(# ); NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "state_pkey" for table "states" CREATE TABLE postgres=# postgres=# drop table states; DROP TABLE postgres=#
</source>