pggeodb-preprod.nancy.inra.fr/db_onf_gde - db_onf_gde on pggeodb-preprod.nancy.inra.fr
Previous topic Chapter index Next topic

View: geography_columns

 

 

Schema

public

 

Owner

postgres

 

Descriptions

There is no description for view geography_columns

 

Fields

Name

Data type

Description

f_table_catalog

name

 

f_table_schema

name

 

f_table_name

name

 

f_geography_column

name

 

coord_dimension

integer

 

srid

integer

 

type

text

 

 

Rules

Name

Event

Instead

Condition

Description

_RETURN

SELECT

 

 

 

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 for PostgreSQL (www.pgsqlmanager.com) at 07/12/2018 13:23
Previous topic Chapter index Next topic