compound_three_primary_keys

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

26 rows where pk2 = "o"

View and edit SQL

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