compound_three_primary_keys

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

26 rows where pk2 = "p"

descending

Link	pk1	pk2	pk3	content
a,p,a	a	p	a	a-p-a
a,p,b	a	p	b	a-p-b
a,p,c	a	p	c	a-p-c
a,p,d	a	p	d	a-p-d
a,p,e	a	p	e	a-p-e
a,p,f	a	p	f	a-p-f
a,p,g	a	p	g	a-p-g
a,p,h	a	p	h	a-p-h
a,p,i	a	p	i	a-p-i
a,p,j	a	p	j	a-p-j
a,p,k	a	p	k	a-p-k
a,p,l	a	p	l	a-p-l
a,p,m	a	p	m	a-p-m
a,p,n	a	p	n	a-p-n
a,p,o	a	p	o	a-p-o
a,p,p	a	p	p	a-p-p
a,p,q	a	p	q	a-p-q
a,p,r	a	p	r	a-p-r
a,p,s	a	p	s	a-p-s
a,p,t	a	p	t	a-p-t
a,p,u	a	p	u	a-p-u
a,p,v	a	p	v	a-p-v
a,p,w	a	p	w	a-p-w
a,p,x	a	p	x	a-p-x
a,p,y	a	p	y	a-p-y
a,p,z	a	p	z	a-p-z

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