Mercurial > lada > lada-server
view db_schema/stammdaten_data_ort_typ.sql @ 1278:b63e0abcbf84
Fixed query for messprogramme to show messprogramme without e-ort.
author | Raimund Renkert <raimund.renkert@intevation.de> |
---|---|
date | Thu, 02 Feb 2017 17:28:31 +0100 |
parents | a4c7057cbaed |
children | 3ac30d816c9a |
line wrap: on
line source
\set ON_ERROR_STOP on -- -- PostgreSQL database dump -- -- Dumped from database version 9.5.1 -- Dumped by pg_dump version 9.5.0 -- Started on 2016-03-31 11:38:13 SET statement_timeout = 0; SET lock_timeout = 0; SET client_encoding = 'UTF8'; SET standard_conforming_strings = on; SET check_function_bodies = false; SET client_min_messages = warning; SET search_path = stammdaten, pg_catalog; -- -- TOC entry 4706 (class 0 OID 535799) -- Dependencies: 272 -- Data for Name: ort_typ; Type: TABLE DATA; Schema: stammdaten; Owner: lada -- COPY ort_typ (id, ort_typ, code) FROM stdin; 1 dynamischer Messpunkt (nicht vordefiniert) DYN 2 vordefinierter Messpunkt GP 3 REI-Messpunkit REI 4 Verwaltungseinheit VE 5 Staat ST 6 Fluss FL 7 See SEE 8 Wasserwerk WW 9 Kläranlage KA 10 Deponie DEP 11 Müllverbrennungsanlage MVA 12 Messstation MST 13 KTA KTA \.