Skip to content

Instantly share code, notes, and snippets.

@Gustry

Gustry/query.sql

Last active July 25, 2018 19:42
Show Gist options
  • Save Gustry/fdc60ffdac81c37ce23ea3a2add109d4 to your computer and use it in GitHub Desktop.
Save Gustry/fdc60ffdac81c37ce23ea3a2add109d4 to your computer and use it in GitHub Desktop.
Download ZIP
SQL get layers without QGIS style
Raw
query.sql
DROP VIEW IF EXISTS liste_des_tables_sans_styles;
CREATE VIEW liste_des_tables_sans_styles AS
SELECT schemaname, tablename
FROM pg_catalog.pg_tables
WHERE schemaname NOT IN ('pg_catalog', 'public', 'information_schema')
EXCEPT
SELECT f_table_schema AS schemaname, f_table_name AS tablename FROM public.layer_styles;
DROP VIEW IF EXISTS liste_des_tables;
CREATE VIEW liste_des_tables AS
SELECT schemaname, tablename
FROM pg_catalog.pg_tables
WHERE schemaname NOT IN ('pg_catalog', 'public', 'information_schema');
DROP VIEW IF EXISTS liste_des_tables_sans_sources;
DROP TABLE IF EXISTS public.sources;
CREATE TABLE public.sources (
schemaname VARCHAR(50) NOT NULL,
tablename VARCHAR(50) NOT NULL,
source TEXT NOT NULL,
PRIMARY KEY (schemaname, tablename)
);
CREATE VIEW liste_des_tables_sans_sources AS
SELECT schemaname, tablename
FROM pg_catalog.pg_tables
WHERE schemaname NOT IN ('pg_catalog', 'public', 'information_schema')
EXCEPT
SELECT schemaname, tablename FROM public.sources;
select * from liste_des_tables;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment