compound_three_primary_keys

Data source: github.com/simon/datasette-psutil · About: /-/psutil demo

13 rows where pk1 = "b" and pk3 = "m"

descending

Link	pk1	pk2	pk3	content
b,a,m	b	a	m	b-a-m
b,b,m	b	b	m	b-b-m
b,c,m	b	c	m	b-c-m
b,d,m	b	d	m	b-d-m
b,e,m	b	e	m	b-e-m
b,f,m	b	f	m	b-f-m
b,g,m	b	g	m	b-g-m
b,h,m	b	h	m	b-h-m
b,i,m	b	i	m	b-i-m
b,j,m	b	j	m	b-j-m
b,k,m	b	k	m	b-k-m
b,l,m	b	l	m	b-l-m
b,m,m	b	m	m	b-m-m

Advanced export

JSON shape: default, array, newline-delimited, object

CREATE TABLE compound_three_primary_keys (
  pk1 varchar(30),
  pk2 varchar(30),
  pk3 varchar(30),
  content text,
  PRIMARY KEY (pk1, pk2, pk3)
);
CREATE INDEX idx_compound_three_primary_keys_content ON compound_three_primary_keys(content);