Mercurial > lada > lada-server
annotate db_schema/stammdaten_data_ort_typ.sql @ 1279:bbfb7c3b5dd8
Add warning to existing client-side fields.
author | Tom Gottfried <tom@intevation.de> |
---|---|
date | Thu, 02 Feb 2017 17:32:30 +0100 |
parents | a4c7057cbaed |
children | 3ac30d816c9a |
rev | line source |
---|---|
1191 | 1 \set ON_ERROR_STOP on |
2 | |
3 -- | |
4 -- PostgreSQL database dump | |
5 -- | |
6 | |
7 -- Dumped from database version 9.5.1 | |
8 -- Dumped by pg_dump version 9.5.0 | |
9 | |
10 -- Started on 2016-03-31 11:38:13 | |
11 | |
12 SET statement_timeout = 0; | |
13 SET lock_timeout = 0; | |
14 SET client_encoding = 'UTF8'; | |
15 SET standard_conforming_strings = on; | |
16 SET check_function_bodies = false; | |
17 SET client_min_messages = warning; | |
18 | |
19 SET search_path = stammdaten, pg_catalog; | |
20 | |
21 | |
22 -- | |
23 -- TOC entry 4706 (class 0 OID 535799) | |
24 -- Dependencies: 272 | |
25 -- Data for Name: ort_typ; Type: TABLE DATA; Schema: stammdaten; Owner: lada | |
26 -- | |
27 | |
1258
cb88ab44c2be
add code to stamdaten.ort_typ
Michael Stanko <mstanko@bfs.de>
parents:
1191
diff
changeset
|
28 COPY ort_typ (id, ort_typ, code) FROM stdin; |
cb88ab44c2be
add code to stamdaten.ort_typ
Michael Stanko <mstanko@bfs.de>
parents:
1191
diff
changeset
|
29 1 dynamischer Messpunkt (nicht vordefiniert) DYN |
cb88ab44c2be
add code to stamdaten.ort_typ
Michael Stanko <mstanko@bfs.de>
parents:
1191
diff
changeset
|
30 2 vordefinierter Messpunkt GP |
cb88ab44c2be
add code to stamdaten.ort_typ
Michael Stanko <mstanko@bfs.de>
parents:
1191
diff
changeset
|
31 3 REI-Messpunkit REI |
cb88ab44c2be
add code to stamdaten.ort_typ
Michael Stanko <mstanko@bfs.de>
parents:
1191
diff
changeset
|
32 4 Verwaltungseinheit VE |
cb88ab44c2be
add code to stamdaten.ort_typ
Michael Stanko <mstanko@bfs.de>
parents:
1191
diff
changeset
|
33 5 Staat ST |
cb88ab44c2be
add code to stamdaten.ort_typ
Michael Stanko <mstanko@bfs.de>
parents:
1191
diff
changeset
|
34 6 Fluss FL |
cb88ab44c2be
add code to stamdaten.ort_typ
Michael Stanko <mstanko@bfs.de>
parents:
1191
diff
changeset
|
35 7 See SEE |
cb88ab44c2be
add code to stamdaten.ort_typ
Michael Stanko <mstanko@bfs.de>
parents:
1191
diff
changeset
|
36 8 Wasserwerk WW |
cb88ab44c2be
add code to stamdaten.ort_typ
Michael Stanko <mstanko@bfs.de>
parents:
1191
diff
changeset
|
37 9 Kläranlage KA |
cb88ab44c2be
add code to stamdaten.ort_typ
Michael Stanko <mstanko@bfs.de>
parents:
1191
diff
changeset
|
38 10 Deponie DEP |
cb88ab44c2be
add code to stamdaten.ort_typ
Michael Stanko <mstanko@bfs.de>
parents:
1191
diff
changeset
|
39 11 Müllverbrennungsanlage MVA |
cb88ab44c2be
add code to stamdaten.ort_typ
Michael Stanko <mstanko@bfs.de>
parents:
1191
diff
changeset
|
40 12 Messstation MST |
cb88ab44c2be
add code to stamdaten.ort_typ
Michael Stanko <mstanko@bfs.de>
parents:
1191
diff
changeset
|
41 13 KTA KTA |
1191 | 42 \. |
43 |