pggeodb-preprod.nancy.inra.fr/db_diams

View: geography_columns

Schema

public

Owner

postgres

Descriptions

There is no description for view geography_columns

Columns

Rules

Indices

There are no indices for table geography_columns

Definition

CREATE VIEW public.geography_columns (
   f_table_catalog,
   f_table_schema,
   f_table_name,
   f_geography_column,
   coord_dimension,
   srid,
   type)
AS
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
   );

This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 07/12/2018 13:23