PRIMARY KEY will create implicit index : Primary Key « Constraints « PostgreSQL






  1. PostgreSQL
  2. Constraints
  3. Primary Key

PRIMARY KEY will create implicit index


postgres=#
postgres=#
postgres=# CREATE TABLE products (
postgres(#    product_no integer PRIMARY KEY,
postgres(#    name text,
postgres(#    price numeric
postgres(# );
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "products_pkey" for table "products"
CREATE TABLE
postgres=#
postgres=# drop table products;
DROP TABLE
postgres=#
postgres=#








Related examples in the same category

1.Implicit index is created when creating a table for a primary key
2.Primary keys constrains more than one column
3.Indicate one column as the primary key column
4.Primary key with check option
5.Add PRIMARY KEY in table creation
6.Use sequence value as a primary key