view db_schema/stammdaten_data_auth_lst_umw.sql @ 1287:3383ca19f7a5

Fixed query to find ort by staat.
author Raimund Renkert <raimund.renkert@intevation.de>
date Wed, 08 Feb 2017 12:01:07 +0100
parents 3923b41f8783
children
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 4672 (class 0 OID 535684)
-- Dependencies: 235
-- Data for Name: auth_lst_umw; Type: TABLE DATA; Schema: stammdaten; Owner: lada
--

COPY auth_lst_umw (id, mst_id, umw_id) FROM stdin;
1	20050	F11
2	20050	F21
3	20050	I11
4	20050	I13
5	20050	I14
6	20050	N11
7	20050	N14
8	20050	N15
9	20050	N2B
10	20050	N3Z
11	20050	N5
12	20050	N8
13	20050	N96
14	20050	N97
15	20050	N9G
16	20050	N9H
17	20050	N9J
18	20050	N9N
19	20050	N2Y
20	20050	N43
21	20050	N53
22	20050	N54
23	20050	N56
24	20050	N95
25	20050	N9D
26	20050	N9I
27	20050	NZ
28	20050	F5
29	20050	F7
30	20050	N2
31	20050	N24
32	20050	N2A
33	20050	N2Z
34	20050	N52
35	20050	N83
36	20050	N87
37	20050	N91
38	20050	N93
39	20050	B36
40	20050	F41
41	20050	F5Z
42	20050	N12
43	20050	N13
44	20050	N21
45	20050	N22
46	20050	N27
47	20050	N29
48	20050	N4
49	20050	N42
50	20050	N44
51	20050	N46
52	20050	N55
53	20050	N94
54	20050	N9B
55	20050	B31
56	20050	B32
57	20050	B33
58	20050	B35
59	20050	F31
60	20050	F6
61	20050	F61
62	20050	F62
63	20050	I15
64	20050	N1
65	20050	N25
66	20050	N28
67	20050	N31
68	20050	N51
69	20050	N9A
70	20050	B34
71	20050	F12
72	20050	N23
73	20050	N2C
74	20050	N45
75	20050	N5Z
76	20050	N82
77	20050	N85
78	20050	N92
79	20050	N9C
80	20050	N9E
81	20050	N9F
82	20050	NZ1
83	20050	NZ2
84	20050	NZZ
85	20050	I12
86	20050	N3
87	20050	N41
88	20050	N4Z
89	20050	N86
90	20050	N98
91	20050	N9K
92	20050	N9M
93	20050	F51
94	20050	F52
95	20050	F63
96	20050	F71
97	20050	N26
98	20050	N81
99	20050	N84
100	20050	N99
101	20050	N9L
102	20040	N64
103	20040	N9P
104	20040	N61
105	20040	N9R
106	20040	N65
107	20040	N6
108	20040	N9O
109	20040	N62
110	20040	N63
111	20040	N9Q
112	20020	G23
113	20020	G13
114	20020	G22
115	20020	G11
116	20020	G12
117	20020	G21
118	20110	I21
119	20110	I32
120	20110	Z33
121	20110	I31
122	20110	Z35
123	20110	I22
124	20110	Z31
125	20110	Z34
126	20110	Z32
127	20090	B12
128	20090	B22
129	20090	B11
130	20090	B21
131	20090	L12
132	20090	L22
133	20090	L31
134	20090	L53
135	20090	L11
136	20090	L21
137	20090	L41
138	20090	L43
139	20090	L51
140	20090	L52
141	20060	A13
142	20060	A31
143	20060	G41
144	20060	G5
145	20060	A41
146	20060	N73
147	20060	N71
148	20060	N72
149	20060	A51
150	20060	A53
151	20060	A21
152	20060	A22
153	20060	A23
154	20060	A24
155	20060	G51
156	20060	GZ1
157	20060	G52
158	20060	N7
159	20060	A52
160	20060	G53
161	20060	A11
162	20060	A12
163	20030	G32
164	20030	G31
165	20030	G33
166	20010	L41
167	20010	L54
168	20010	L43
169	20010	L51
170	20010	L53
171	20010	M
172	20010	L31
173	20010	L52
174	20120	L63
175	20120	L42
176	20120	L62
177	20120	L61
\.
This site is hosted by Intevation GmbH (Datenschutzerklärung und Impressum | Privacy Policy and Imprint)