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