Constraints PostgreSQL

  1. Home
  2. PostgreSQL
  3. Constraints
  4. Implicit index is created when creating a table for a primary key
postgres=#
postgres=# CREATE TABLE authors (id integer PRIMARY KEY,
postgres(#                       last_name text,
postgres(#                       first_name text);
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "authors_pkey" for table "authors"
CREATE TABLE
postgres=#
postgres=# drop table authors;
DROP TABLE
postgres=#