compound_three_primary_keys

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

39 rows where pk3 = "c" sorted by pk3

descending

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

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