1
SELECT current_database() AS f_table_catalog,
2
n.nspname AS f_table_schema,
3
c.relname AS f_table_name,
4
a.attname AS f_geography_column,
5
postgis_typmod_dims(a.atttypmod) AS coord_dimension,
6
postgis_typmod_srid(a.atttypmod) AS srid,
7
postgis_typmod_type(a.atttypmod) AS type
8
FROM pg_class c,
9
pg_attribute a,
10
pg_type t,
11
pg_namespace n
12
WHERE ((t.typname = 'geography'::name) AND (a.attisdropped = false) AND (a.atttypid = t.oid) AND (a.attrelid = c.oid) AND (c.relnamespace = n.oid) AND (c.relkind = ANY (ARRAY['r'::"char", 'v'::"char", 'm'::"char", 'f'::"char", 'p'::"char"])) AND (NOT pg_is_other_temp_schema(c.relnamespace)) AND has_table_privilege(c.oid, 'SELECT'::text));