P3wsg912

1--
2-- PostgreSQL database dump
3--
4
5-- Dumped from database version 9.6.1
6-- Dumped by pg_dump version 9.6.1
7
8SET statement_timeout = 0;
9SET lock_timeout = 0;
10SET idle_in_transaction_session_timeout = 0;
11SET client_encoding = 'UTF8';
12SET standard_conforming_strings = on;
13SET check_function_bodies = false;
14SET client_min_messages = warning;
15SET row_security = off;
16
17--
18-- Name: plpgsql; Type: EXTENSION; Schema: -; Owner:
19--
20
21CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;
22
23
24--
25-- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner:
26--
27
28COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';
29
30
31SET search_path = public, pg_catalog;
32
33SET default_tablespace = '';
34
35SET default_with_oids = false;
36
37--
38-- Name: t1; Type: TABLE; Schema: public; Owner: myUser
39--
40
41CREATE TABLE t1 (
42    f1 smallint NOT NULL,
43    f2 text
44);
45
46
47ALTER TABLE t1 OWNER TO "myUser";
48
49--
50-- Name: t2; Type: TABLE; Schema: public; Owner: myUser
51--
52
53CREATE TABLE t2 (
54    f1 smallint,
55    f2 smallint
56);
57
58
59ALTER TABLE t2 OWNER TO "myUser";
60
61--
62-- Name: v1; Type: TABLE; Schema: public; Owner: myUser
63--
64
65CREATE TABLE v1 (
66    f1 smallint,
67    f2 text,
68    sum bigint
69);
70
71ALTER TABLE ONLY v1 REPLICA IDENTITY NOTHING;
72
73
74ALTER TABLE v1 OWNER TO "myUser";
75
76--
77-- Data for Name: t1; Type: TABLE DATA; Schema: public; Owner: myUser
78--
79
80COPY t1 (f1, f2) FROM stdin;
811       a
822       b
833       c
845       e
85\.
86
87
88--
89-- Data for Name: t2; Type: TABLE DATA; Schema: public; Owner: myUser
90--
91
92COPY t2 (f1, f2) FROM stdin;
931       2
941       3
952       9
962       9
973       5
983       5
995       9
100\.
101
102
103--
104-- Name: v1 _RETURN; Type: RULE; Schema: public; Owner: myUser
105--
106
107CREATE RULE "_RETURN" AS
108    ON SELECT TO v1 DO INSTEAD  SELECT t1.f1,
109    t1.f2,
110    sum(t2.f2) AS sum
111   FROM (t1
112     JOIN t2 ON ((t1.f1 = t2.f1)))
113  GROUP BY t1.f1;
114  
115  
116REVOKE ALL ON SCHEMA public FROM postgres;
117REVOKE ALL ON SCHEMA public FROM PUBLIC;
118GRANT ALL ON SCHEMA public TO "myUser";
119GRANT ALL ON SCHEMA public TO PUBLIC;