compound_three_primary_keys

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

26 rows where pk1 = "a" and pk2 = "a"

View and edit SQL

pk2

pk1

Link pk1 pk2 pk3 content
a a a a-a-a
a a b a-a-b
a a c a-a-c
a a d a-a-d
a a e a-a-e
a a f a-a-f
a a g a-a-g
a a h a-a-h
a a i a-a-i
a a j a-a-j
a a k a-a-k
a a l a-a-l
a a m a-a-m
a a n a-a-n
a a o a-a-o
a a p a-a-p
a a q a-a-q
a a r a-a-r
a a s a-a-s
a a t a-a-t
a a u a-a-u
a a v a-a-v
a a w a-a-w
a a x a-a-x
a a y a-a-y
a a z a-a-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.514ms · Data source: github.com/simon/datasette-psutil · About: /-/psutil demo