compound_three_primary_keys

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

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

descending

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

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