· 7 years ago · Sep 30, 2018, 05:06 PM
1PGDMP
2 %
3 v Shoes 10.5 10.4 m 0 0 ENCODING ENCODING SET client_encoding = 'UTF8';
4 false n 0 0
5 STDSTRINGS
6 STDSTRINGS ( SET standard_conforming_strings = 'on';
7 false o 0 0
8 SEARCHPATH
9 SEARCHPATH 8 SELECT pg_catalog.set_config('search_path', '', false);
10 false p 1262 16389 Shoes DATABASE — CREATE DATABASE "Shoes" WITH TEMPLATE = template0 ENCODING = 'UTF8' LC_COLLATE = 'English_United States.1252' LC_CTYPE = 'English_United States.1252';
11 DROP DATABASE "Shoes";
12 postgres false 2615 16390 Shoes SCHEMA CREATE SCHEMA "Shoes";
13 DROP SCHEMA "Shoes";
14 postgres false 2615 2200 public SCHEMA CREATE SCHEMA public;
15 DROP SCHEMA public;
16 postgres false q 0 0
17 SCHEMA public COMMENT 6 COMMENT ON SCHEMA public IS 'standard public schema';
18 postgres false 3 3079 12278 plpgsql EXTENSION ? CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;
19 DROP EXTENSION plpgsql;
20 false r 0 0 EXTENSION plpgsql COMMENT @ COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';
21 false 1 Ã… 1259 16391 Shoes TABLE " CREATE TABLE "Shoes"."Shoes" (
22);
23 DROP TABLE "Shoes"."Shoes";
24 Shoes postgres false 7 Ç 1259 16396 resources TABLE á CREATE TABLE public.resources (
25 id integer NOT NULL,
26 created_at timestamp with time zone,
27 updated_at timestamp with time zone,
28 deleted_at timestamp with time zone,
29 name text,
30 tts text,
31 ttc text
32);
33 DROP TABLE public.resources;
34 public postgres false 3 Æ 1259 16394 resources_id_seq SEQUENCE ˆ CREATE SEQUENCE public.resources_id_seq
35 AS integer
36 START WITH 1
37 INCREMENT BY 1
38 NO MINVALUE
39 NO MAXVALUE
40 CACHE 1;
41 ' DROP SEQUENCE public.resources_id_seq;
42 public postgres false 3 199 s 0 0 resources_id_seq SEQUENCE OWNED BY E ALTER SEQUENCE public.resources_id_seq OWNED BY public.resources.id;
43 public postgres false 198 î 2604 16399 resources id DEFAULT l ALTER TABLE ONLY public.resources ALTER COLUMN id SET DEFAULT nextval('public.resources_id_seq'::regclass);
44 ; ALTER TABLE public.resources ALTER COLUMN id DROP DEFAULT;
45 public postgres false 198 199 199 ñ 2606 16404 resources resources_pkey
46 CONSTRAINT V ALTER TABLE ONLY public.resources
47 ADD CONSTRAINT resources_pkey PRIMARY KEY (id);
48 B ALTER TABLE ONLY public.resources DROP CONSTRAINT resources_pkey;
49 public postgres false 199 ï 1259 16405 idx_resources_deleted_at INDEX T CREATE INDEX idx_resources_deleted_at ON public.resources USING btree (deleted_at);
50 , DROP INDEX public.idx_resources_deleted_at;
51 public postgres false 199