pg-tpch/primary_keys.sql at master · 2ndQuadrant/pg-tpch · GitHub

1
2
3
4
5
6
7
8
ALTER TABLE customer ADD CONSTRAINT pk_customer PRIMARY KEY USING INDEX pk_customer;
ALTER TABLE lineitem ADD CONSTRAINT pk_lineitem PRIMARY KEY USING INDEX pk_lineitem;
ALTER TABLE nation ADD CONSTRAINT pk_nation PRIMARY KEY USING INDEX pk_nation;
ALTER TABLE orders ADD CONSTRAINT pk_orders PRIMARY KEY USING INDEX pk_orders;
ALTER TABLE part ADD CONSTRAINT pk_part PRIMARY KEY USING INDEX pk_part;
ALTER TABLE partsupp ADD CONSTRAINT pk_partsupp PRIMARY KEY USING INDEX pk_partsupp;
ALTER TABLE region ADD CONSTRAINT pk_region PRIMARY KEY USING INDEX pk_region;
ALTER TABLE supplier ADD CONSTRAINT pk_supplier PRIMARY KEY USING INDEX pk_supplier;