views

12 rows sorted by name

descending

id	database_id	name ▼
1	timezones 10	geom_cols_ref_sys
7	wtr 13	geom_cols_ref_sys
2	timezones 10	spatial_ref_sys_all
8	wtr 13	spatial_ref_sys_all
3	timezones 10	vector_layers
9	wtr 13	vector_layers
4	timezones 10	vector_layers_auth
10	wtr 13	vector_layers_auth
6	timezones 10	vector_layers_field_infos
12	wtr 13	vector_layers_field_infos
5	timezones 10	vector_layers_statistics
11	wtr 13	vector_layers_statistics

Advanced export

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

CREATE TABLE views (
            id integer PRIMARY KEY,
            database_id integer,
            name text,
            FOREIGN KEY (database_id) REFERENCES databases(id)
        );