github.com/cockroachdb/cockroach@v20.2.0-alpha.1+incompatible/pkg/cli/testdata/dump/primary_key (about) 1 # Test that a primary key with a non-default name works. 2 3 sql 4 CREATE DATABASE d; 5 CREATE TABLE d.t ( 6 i int, 7 CONSTRAINT pk_name PRIMARY KEY (i) 8 ); 9 INSERT INTO d.t VALUES (1); 10 ---- 11 INSERT 1 12 13 dump d t 14 ---- 15 ---- 16 CREATE TABLE t ( 17 i INT8 NOT NULL, 18 CONSTRAINT pk_name PRIMARY KEY (i ASC), 19 FAMILY "primary" (i) 20 ); 21 22 INSERT INTO t (i) VALUES 23 (1); 24 ---- 25 ----