table_with_compound_pk

21 rows

View and edit SQL

Suggested facets: pk2

pk1

Link pk1 pk2 name
1 1 Row 1 1
1 2 Row 1 2
1 3 Row 1 3
1 4 Row 1 4
1 5 Row 1 5
1 6 Row 1 6
1 7 Row 1 7
2 1 Row 2 1
2 2 Row 2 2
2 3 Row 2 3
2 4 Row 2 4
2 5 Row 2 5
2 6 Row 2 6
2 7 Row 2 7
3 1 Row 3 1
3 2 Row 3 2
3 3 Row 3 3
3 4 Row 3 4
3 5 Row 3 5
3 6 Row 3 6
3 7 Row 3 7

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE [table_with_compound_pk] (
   [pk1] INTEGER,
   [pk2] INTEGER,
   [name] TEXT,
   PRIMARY KEY ([pk1], [pk2])
);
Powered by Datasette · Query took 12.473ms · About: simonw/datasette-graphql