Mega Code Archive

 

Categories / PostgreSQL / Constraints

 

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=#