compound_three_primary_keys

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

26 rows where pk2 = "t"

View and edit SQL

pk2

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