compound_three_primary_keys

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

26 rows where pk2 = "r"

View and edit SQL

pk2

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