view db_schema/stammdaten_data_ort_typ.sql @ 1277:15700d7c00eb

According to database schema, ort.ort_typ is allowed to be NULL.
author Tom Gottfried <tom@intevation.de>
date Thu, 02 Feb 2017 15:41:05 +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
\.
This site is hosted by Intevation GmbH (Datenschutzerklärung und Impressum | Privacy Policy and Imprint)