Sauvegarde pour exercice
1
--
2
-- PostgreSQL database dump
3
--
4
5
-- Dumped from database version 9.6.7
6
-- Dumped by pg_dump version 9.6.7
7
8
SET statement_timeout = 0;
9
SET lock_timeout = 0;
10
SET idle_in_transaction_session_timeout = 0;
11
SET client_encoding = 'UTF8';
12
SET standard_conforming_strings = on;
13
SET check_function_bodies = false;
14
SET client_min_messages = warning;
15
SET row_security = off;
16
17
DROP DATABASE exo1;
18
--
19
-- Name: exo1; Type: DATABASE; Schema: -; Owner: postgres
20
--
21
22
CREATE DATABASE exo1 WITH TEMPLATE = template0 ENCODING = 'UTF8' LC_COLLATE = 'fr_FR.UTF-8' LC_CTYPE = 'fr_FR.UTF-8';
23
24
25
ALTER DATABASE exo1 OWNER TO postgres;
26
27
\connect exo1
28
29
SET statement_timeout = 0;
30
SET lock_timeout = 0;
31
SET idle_in_transaction_session_timeout = 0;
32
SET client_encoding = 'UTF8';
33
SET standard_conforming_strings = on;
34
SET check_function_bodies = false;
35
SET client_min_messages = warning;
36
SET row_security = off;
37
38
--
39
-- Name: plpgsql; Type: EXTENSION; Schema: -; Owner:
40
--
41
42
CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;
43
44
45
--
46
-- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner:
47
--
48
49
COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';
50
51
52
SET search_path = public, pg_catalog;
53
54
SET default_tablespace = '';
55
56
SET default_with_oids = false;
57
58
--
59
-- Name: rootme; Type: TABLE; Schema: public; Owner: postgres
60
--
61
62
CREATE TABLE rootme (
63
id integer
64
);
65
66
67
ALTER TABLE rootme OWNER TO postgres;
68
69
--
70
-- Data for Name: rootme; Type: TABLE DATA; Schema: public; Owner: postgres
71
--
72
73
COPY rootme (id) FROM stdin;
74
\.
75
76
77
--
78
-- Name: SCHEMA public; Type: ACL; Schema: -; Owner: postgres
79
--
80
81
GRANT ALL ON SCHEMA public TO PUBLIC;
82
83
84
--
85
-- PostgreSQL database dump complete
86
--
87
88