v_export_table

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

uid

uuid

2147483647

√

null

table_name

text

2147483647

√

null

schema_name

text

2147483647

√

null

title

text

2147483647

√

null

abstract

text

2147483647

√

null

View Definition

SELECT d.uid,
    d.table_name,
    d.schema_name,
    d.title,
    d.abstract,
    d.categories,
    d.themes,
    d.keywords,
    d.spatial_level,
    d.minimum_optimal_scale,
    d.maximum_optimal_scale,
    d.publication_date,
    d.publication_frequency,
    d.license,
    d.confidentiality,
    d.feature_count,
    d.geometry_type,
    d.projection_name,
    d.projection_authid,
    d.spatial_extent,
    d.creation_date,
    d.update_date,
    d.data_last_update,
    string_agg(((l.name || ': '::text) || l.url), ', '::text) AS links,
    string_agg((((((c.name || ' ('::text) || c.organisation_name) || ')'::text) || ' - '::text) || c.contact_role), ', '::text) AS contacts
   FROM ((pgmetadata.v_dataset d
     LEFT JOIN pgmetadata.v_link l ON (((l.table_name = d.table_name) AND (l.schema_name = d.schema_name))))
     LEFT JOIN pgmetadata.v_contact c ON (((c.table_name = d.table_name) AND (c.schema_name = d.schema_name))))
  GROUP BY d.uid, d.table_name, d.schema_name, d.title, d.abstract, d.categories, d.themes, d.keywords, d.spatial_level, d.minimum_optimal_scale, d.maximum_optimal_scale, d.publication_date, d.publication_frequency, d.license, d.confidentiality, d.feature_count, d.geometry_type, d.projection_name, d.projection_authid, d.spatial_extent, d.creation_date, d.update_date, d.data_last_update
  ORDER BY d.schema_name, d.table_name;

Description

Columns

View Definition

Possibly Referenced Tables/Views