geography_columns

SELECT current_database() AS f_table_catalog,

    n.nspname AS f_table_schema,

    c.relname AS f_table_name,

    a.attname AS f_geography_column,

    postgis_typmod_dims(a.atttypmod) AS coord_dimension,

    postgis_typmod_srid(a.atttypmod) AS srid,

    postgis_typmod_type(a.atttypmod) AS type

   FROM pg_class c,

    pg_attribute a,

    pg_type t,

    pg_namespace n

  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));