ywqMH4da

1DROP VIEW IF EXISTS liste_des_tables_sans_styles;
2CREATE VIEW liste_des_tables_sans_styles AS
3SELECT schemaname, tablename
4FROM pg_catalog.pg_tables
5WHERE schemaname NOT IN ('pg_catalog', 'public', 'information_schema')
6EXCEPT
7SELECT f_table_schema AS schemaname, f_table_name AS tablename FROM public.layer_styles;
8
9DROP VIEW IF EXISTS liste_des_tables;
10CREATE VIEW liste_des_tables AS
11SELECT schemaname, tablename
12FROM pg_catalog.pg_tables
13WHERE schemaname NOT IN ('pg_catalog', 'public', 'information_schema');
14
15DROP VIEW IF EXISTS liste_des_tables_sans_sources;
16DROP TABLE IF EXISTS public.sources;
17CREATE TABLE public.sources (
18	schemaname VARCHAR(50) NOT NULL,
19	tablename VARCHAR(50) NOT NULL,
20	source TEXT NOT NULL,
21	PRIMARY KEY (schemaname, tablename)
22);
23
24CREATE VIEW liste_des_tables_sans_sources AS
25SELECT schemaname, tablename
26FROM pg_catalog.pg_tables
27WHERE schemaname NOT IN ('pg_catalog', 'public', 'information_schema')
28EXCEPT
29SELECT schemaname, tablename FROM public.sources;
30
31select * from liste_des_tables;