postgre 主键_PostgreSQL实现主键索引

PostgreSQL实现主键索引

1 单主键

①:

CREATE TABLE products (

id integer PRIMARY KEY

);

②:

CREATE TABLE products (

id integer,

PRIMARY KEY(id)

);

2 多主键

CREATE TABLE products(

a integer,

b integer,

c integer,

PRIMARY KEY (b,c)

);

3 自增主键

CREATE TABLE products (

id serial PRIMARY KEY --或serial换成bigserial

);

4 单字段索引

CREATE TABLE test1 (

id integer,

content varchar

);

CREATE INDEX test1_id_index ON test1 (id);

5 多字段索引

CREATE TABLE test1 (

id integer,

num integer,

content varchar

);

CREATE INDEX test1_id_index ON test1 (id,num);