pggeodb.nancy.inra.fr/db_croissance - db_croissance on pggeodb.nancy.inra.fr

View: geography_columns

Schema

public

Owner

postgres

Descriptions

There is no description for view geography_columns

Fields

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 NOT pg_is_other_temp_schema(c.relnamespace) AND has_table_privilege(c.oid, '
   SELECT'::text
   );

This file was generated with SQL Manager 2011 for PostgreSQL (www.pgsqlmanager.com) at 28/03/2012 14:37