compound_three_primary_keys

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

26 rows where pk2 = "p"

View and edit SQL

pk2

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