| 1 | -- |
| 2 | -- PostgreSQL database dump |
| 3 | -- |
| 4 | |
| 5 | -- Dumped from database version 9.5.19 |
| 6 | -- Dumped by pg_dump version 9.5.19 |
| 7 | |
| 8 | SET statement_timeout = 0; |
| 9 | SET lock_timeout = 0; |
| 10 | SET client_encoding = 'UTF8'; |
| 11 | SET standard_conforming_strings = on; |
| 12 | SELECT pg_catalog.set_config('search_path', '', false); |
| 13 | SET check_function_bodies = false; |
| 14 | SET xmloption = content; |
| 15 | SET client_min_messages = warning; |
| 16 | SET row_security = off; |
| 17 | |
| 18 | -- |
| 19 | -- Name: plpgsql; Type: EXTENSION; Schema: -; Owner: |
| 20 | -- |
| 21 | |
| 22 | CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog; |
| 23 | |
| 24 | |
| 25 | -- |
| 26 | -- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner: |
| 27 | -- |
| 28 | |
| 29 | COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language'; |
| 30 | |
| 31 | |
| 32 | SET default_tablespace = ''; |
| 33 | |
| 34 | SET default_with_oids = false; |
| 35 | |
| 36 | -- |
| 37 | -- Name: customers; Type: TABLE; Schema: public; Owner: myuser |
| 38 | -- |
| 39 | |
| 40 | CREATE TABLE public.customers ( |
| 41 | id integer NOT NULL, |
| 42 | name text DEFAULT ''::text, |
| 43 | nr_orders integer DEFAULT 0, |
| 44 | country text DEFAULT 'England'::text, |
| 45 | created_at timestamp without time zone DEFAULT now() |
| 46 | ); |
| 47 | |
| 48 | |
| 49 | ALTER TABLE public.customers OWNER TO myuser; |
| 50 | |
| 51 | -- |
| 52 | -- Name: customers_id_seq; Type: SEQUENCE; Schema: public; Owner: myuser |
| 53 | -- |
| 54 | |
| 55 | CREATE SEQUENCE public.customers_id_seq |
| 56 | START WITH 1 |
| 57 | INCREMENT BY 1 |
| 58 | NO MINVALUE |
| 59 | NO MAXVALUE |
| 60 | CACHE 1; |
| 61 | |
| 62 | |
| 63 | ALTER TABLE public.customers_id_seq OWNER TO myuser; |
| 64 | |
| 65 | -- |
| 66 | -- Name: customers_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: myuser |
| 67 | -- |
| 68 | |
| 69 | ALTER SEQUENCE public.customers_id_seq OWNED BY public.customers.id; |
| 70 | |
| 71 | |
| 72 | -- |
| 73 | -- Name: id; Type: DEFAULT; Schema: public; Owner: myuser |
| 74 | -- |
| 75 | |
| 76 | ALTER TABLE ONLY public.customers ALTER COLUMN id SET DEFAULT nextval('public.customers_id_seq'::regclass); |
| 77 | |
| 78 | |
| 79 | -- |
| 80 | -- Data for Name: customers; Type: TABLE DATA; Schema: public; Owner: myuser |
| 81 | -- |
| 82 | |
| 83 | COPY public.customers (id, name, nr_orders, country, created_at) FROM stdin; |
| 84 | 2 Pippi Långstrump 3 Bulgaria 2019-08-19 09:41:30.78888 |
| 85 | 1 Bilbo Begins 11 Bulgaria 2019-08-19 09:40:31.396807 |
| 86 | 3 Viktualia Rullgardina 0 Bulgaria 2019-08-19 09:42:52.723223 |
| 87 | 4 Krusmynta Efraimsdotter 5 Bulgaria 2019-08-19 09:43:04.083209 |
| 88 | 5 Ana Karenina 0 Russia 2019-08-20 15:41:50.244971 |
| 89 | 7 Jiji Lolobridgida 0 Italy 2019-08-20 15:42:26.020113 |
| 90 | 6 Viktor Savashkin 8 Russia 2019-08-20 15:42:07.213557 |
| 91 | \. |
| 92 | |
| 93 | |
| 94 | -- |
| 95 | -- Name: customers_id_seq; Type: SEQUENCE SET; Schema: public; Owner: myuser |
| 96 | -- |
| 97 | |
| 98 | SELECT pg_catalog.setval('public.customers_id_seq', 1, true); |
| 99 | |
| 100 | |
| 101 | -- |
| 102 | -- Name: customers_pkey; Type: CONSTRAINT; Schema: public; Owner: myuser |
| 103 | -- |
| 104 | |
| 105 | ALTER TABLE ONLY public.customers |
| 106 | ADD CONSTRAINT customers_pkey PRIMARY KEY (id); |
| 107 | |
| 108 | |
| 109 | -- |
| 110 | -- Name: SCHEMA public; Type: ACL; Schema: -; Owner: postgres |
| 111 | -- |
| 112 | |
| 113 | REVOKE ALL ON SCHEMA public FROM PUBLIC; |
| 114 | REVOKE ALL ON SCHEMA public FROM postgres; |
| 115 | GRANT ALL ON SCHEMA public TO postgres; |
| 116 | GRANT ALL ON SCHEMA public TO PUBLIC; |
| 117 | |
| 118 | |
| 119 | -- |
| 120 | -- PostgreSQL database dump complete |
| 121 | -- |
| 122 | |
| 123 | |