compound_three_primary_keys

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

26 rows where pk2 = "q"

View and edit SQL

pk2

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

Advanced export

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

CSV options:

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);
Powered by Datasette · Query took 11.97ms · Data source: github.com/simon/datasette-psutil · About: /-/psutil demo