db_check.sql
498 Bytes
SELECT table_name FROM information_schema.tables WHERE table_schema = 'public' AND table_name LIKE 'snc_%';
SELECT column_name, data_type FROM information_schema.columns WHERE table_name = 'snc_raw_distritos' ORDER BY ordinal_position;
SELECT column_name, data_type FROM information_schema.columns WHERE table_name = 'snc_raw_departamentos' ORDER BY ordinal_position;
SELECT column_name, data_type FROM information_schema.columns WHERE table_name = 'snc_catalog_mapping' ORDER BY ordinal_position;