Constraints PostgreSQL

  1. Home
  2. PostgreSQL
  3. Constraints
  4. Add PRIMARY KEY in table creation
postgres=#
postgres=# CREATE TABLE new_books
postgres-#               (id integer CONSTRAINT books_id_pkey PRIMARY KEY,
postgres(#               title text NOT NULL,
postgres(#               author_id integer,
postgres(#               subject_id integer);
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "books_id_pkey" for table "new_books"
CREATE TABLE
postgres=#
postgres=# drop table new_books;
DROP TABLE
postgres=#