Mercurial > gemma

view schema/updates/1461/01.config.sql @ 5560:f2204f91d286

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Join the log lines of imports to the log exports to recover data from them. Used in SR export to extract information that where in the meta json but now are only found in the log.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Wed, 09 Feb 2022 18:34:40 +0100
parents 24156a964eaa
children
line wrap: on
line source

-- GeoServer SQL views without time support
INSERT INTO sys_admin.published_services (
    schema, name, srid, key_column, view_def
) VALUES
    ('waterway', 'sounding_results_marking_points_geoserver', 4326, NULL, $$
        SELECT bottleneck_id,
            to_char(date_info, 'YYYY-MM-DD') AS date_info,
            height,
            points,
            surtyp,
            zpg_exception
        FROM waterway.sounding_results_marking_points mp
            JOIN waterway.sounding_results sr ON sr.id = mp.sounding_result_id
    $$);