pggeodb-preprod.nancy.inra.fr/db_diams

View: raster_overviews

Schema

public

Owner

postgres

Descriptions

There is no description for view raster_overviews

Columns

Rules

Indices

There are no indices for table raster_overviews

Definition

CREATE VIEW public.raster_overviews (
   o_table_catalog,
   o_table_schema,
   o_table_name,
   o_raster_column,
   r_table_catalog,
   r_table_schema,
   r_table_name,
   r_raster_column,
   overview_factor)
AS
SELECT current_database() AS o_table_catalog,
   n.nspname AS o_table_schema,
   c.relname AS o_table_name,
   a.attname AS o_raster_column,
   current_database() AS r_table_catalog,
   split_part(split_part(s.consrc, '''::name'::text, 1), ''''::text, 2)::name
       AS r_table_schema,
   split_part(split_part(s.consrc, '''::name'::text, 2), ''''::text, 2)::name
       AS r_table_name,
   split_part(split_part(s.consrc, '''::name'::text, 3), ''''::text, 2)::name
       AS r_raster_column,
   TRIM(BOTH
FROM split_part(s.consrc, ','::text, 2))::integer AS overview_factor
FROM pg_class c,
   pg_attribute a,
   pg_type t,
   pg_namespace n,
   (
   SELECT pg_constraint.connamespace,
           pg_constraint.conrelid,
           pg_constraint.conkey,
           pg_get_constraintdef(pg_constraint.oid) AS consrc
   FROM pg_constraint
   ) s
WHERE t.typname = 'raster'::name AND a.attisdropped = false AND a.atttypid =
   t.oid AND a.attrelid = c.oid AND c.relnamespace = n.oid AND (c.relkind::text = ANY (ARRAY['r'::character(1), 'v'::character(1), 'm'::character(1), 'f'::character(1)]::text[])) AND s.connamespace = n.oid AND s.conrelid = c.oid AND s.consrc ~~ '%_overview_constraint(%'::text 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