test pgloader dump

gistfile1.txt

--
-- PostgreSQL database dump
--

-- Dumped from database version 15.2
-- Dumped by pg_dump version 15.3 (Homebrew)

SET statement_timeout = 0;
SET lock_timeout = 0;
SET idle_in_transaction_session_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SELECT pg_catalog.set_config('search_path', '', false);
SET check_function_bodies = false;
SET xmloption = content;
SET client_min_messages = warning;
SET row_security = off;

SET default_tablespace = '';

SET default_with_oids = false;

CREATE SCHEMA before;

--
-- Name: ar_internal_metadata; Type: TABLE; Schema: before; Owner: postgres
--

CREATE TABLE before.ar_internal_metadata (
    key character varying NOT NULL,
    value character varying
);


ALTER TABLE before.ar_internal_metadata OWNER TO postgres;

--
-- Name: concurrencies; Type: TABLE; Schema: before; Owner: postgres
--

CREATE TABLE before.concurrencies (
    id bigint NOT NULL,
    level numeric
);


ALTER TABLE before.concurrencies OWNER TO postgres;

--
-- Name: concurrencies_id_seq; Type: SEQUENCE; Schema: before; Owner: postgres
--

CREATE SEQUENCE before.concurrencies_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE before.concurrencies_id_seq OWNER TO postgres;

--
-- Name: concurrencies_id_seq; Type: SEQUENCE OWNED BY; Schema: before; Owner: postgres
--

ALTER SEQUENCE before.concurrencies_id_seq OWNED BY before.concurrencies.id;


--
-- Name: frameworks; Type: TABLE; Schema: before; Owner: postgres
--

CREATE TABLE before.frameworks (
    id bigint NOT NULL,
    language_id bigint,
    label character varying
);


ALTER TABLE before.frameworks OWNER TO postgres;

--
-- Name: frameworks_id_seq; Type: SEQUENCE; Schema: before; Owner: postgres
--

CREATE SEQUENCE before.frameworks_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE before.frameworks_id_seq OWNER TO postgres;

--
-- Name: frameworks_id_seq; Type: SEQUENCE OWNED BY; Schema: before; Owner: postgres
--

ALTER SEQUENCE before.frameworks_id_seq OWNED BY before.frameworks.id;


--
-- Name: keys; Type: TABLE; Schema: before; Owner: postgres
--

CREATE TABLE before.keys (
    id bigint NOT NULL,
    label character varying
);


ALTER TABLE before.keys OWNER TO postgres;

--
-- Name: keys_id_seq; Type: SEQUENCE; Schema: before; Owner: postgres
--

CREATE SEQUENCE before.keys_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE before.keys_id_seq OWNER TO postgres;

--
-- Name: keys_id_seq; Type: SEQUENCE OWNED BY; Schema: before; Owner: postgres
--

ALTER SEQUENCE before.keys_id_seq OWNED BY before.keys.id;


--
-- Name: languages; Type: TABLE; Schema: before; Owner: postgres
--

CREATE TABLE before.languages (
    id bigint NOT NULL,
    label character varying
);


ALTER TABLE before.languages OWNER TO postgres;

--
-- Name: languages_id_seq; Type: SEQUENCE; Schema: before; Owner: postgres
--

CREATE SEQUENCE before.languages_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE before.languages_id_seq OWNER TO postgres;

--
-- Name: languages_id_seq; Type: SEQUENCE OWNED BY; Schema: before; Owner: postgres
--

ALTER SEQUENCE before.languages_id_seq OWNED BY before.languages.id;


--
-- Name: metrics; Type: TABLE; Schema: before; Owner: postgres
--

CREATE TABLE before.metrics (
    framework_id bigint,
    value_id bigint,
    concurrency_id bigint
);


ALTER TABLE before.metrics OWNER TO postgres;

--
-- Name: schema_migrations; Type: TABLE; Schema: before; Owner: postgres
--

CREATE TABLE before.schema_migrations (
    version character varying NOT NULL
);


ALTER TABLE before.schema_migrations OWNER TO postgres;

--
-- Name: values; Type: TABLE; Schema: before; Owner: postgres
--

CREATE TABLE before."values" (
    id bigint NOT NULL,
    value double precision,
    key_id bigint
);


ALTER TABLE before."values" OWNER TO postgres;

--
-- Name: values_id_seq; Type: SEQUENCE; Schema: before; Owner: postgres
--

CREATE SEQUENCE before.values_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE before.values_id_seq OWNER TO postgres;

--
-- Name: values_id_seq; Type: SEQUENCE OWNED BY; Schema: before; Owner: postgres
--

ALTER SEQUENCE before.values_id_seq OWNED BY before."values".id;


--
-- Name: writable; Type: TABLE; Schema: before; Owner: postgres
--

CREATE TABLE before.writable (
    language_id bigint,
    framework_id bigint
);


ALTER TABLE before.writable OWNER TO postgres;

--
-- Name: concurrencies id; Type: DEFAULT; Schema: before; Owner: postgres
--

ALTER TABLE ONLY before.concurrencies ALTER COLUMN id SET DEFAULT nextval('before.concurrencies_id_seq'::regclass);


--
-- Name: frameworks id; Type: DEFAULT; Schema: before; Owner: postgres
--

ALTER TABLE ONLY before.frameworks ALTER COLUMN id SET DEFAULT nextval('before.frameworks_id_seq'::regclass);


--
-- Name: keys id; Type: DEFAULT; Schema: before; Owner: postgres
--

ALTER TABLE ONLY before.keys ALTER COLUMN id SET DEFAULT nextval('before.keys_id_seq'::regclass);


--
-- Name: languages id; Type: DEFAULT; Schema: before; Owner: postgres
--

ALTER TABLE ONLY before.languages ALTER COLUMN id SET DEFAULT nextval('before.languages_id_seq'::regclass);


--
-- Name: values id; Type: DEFAULT; Schema: before; Owner: postgres
--

ALTER TABLE ONLY before."values" ALTER COLUMN id SET DEFAULT nextval('before.values_id_seq'::regclass);


--
-- Data for Name: ar_internal_metadata; Type: TABLE DATA; Schema: before; Owner: postgres
--

COPY before.ar_internal_metadata (key, value, created_at, updated_at) FROM stdin;
environment	default_env	2020-02-09 14:44:04.669806	2020-02-09 14:44:04.669806
\.


--
-- Data for Name: concurrencies; Type: TABLE DATA; Schema: before; Owner: postgres
--

COPY before.concurrencies (id, level) FROM stdin;
\.


--
-- Data for Name: frameworks; Type: TABLE DATA; Schema: before; Owner: postgres
--

COPY before.frameworks (id, language_id, label) FROM stdin;
\.


--
-- Data for Name: keys; Type: TABLE DATA; Schema: before; Owner: postgres
--

COPY before.keys (id, label) FROM stdin;
\.


--
-- Data for Name: languages; Type: TABLE DATA; Schema: before; Owner: postgres
--

COPY before.languages (id, label) FROM stdin;
\.


--
-- Data for Name: metrics; Type: TABLE DATA; Schema: before; Owner: postgres
--

COPY before.metrics (framework_id, value_id, concurrency_id) FROM stdin;
\.


--
-- Data for Name: schema_migrations; Type: TABLE DATA; Schema: before; Owner: postgres
--

COPY before.schema_migrations (version) FROM stdin;
20191014111447
20200209161533
\.


--
-- Data for Name: values; Type: TABLE DATA; Schema: before; Owner: postgres
--

COPY before."values" (id, value, key_id) FROM stdin;
\.


--
-- Data for Name: writable; Type: TABLE DATA; Schema: before; Owner: postgres
--

COPY before.writable (language_id, framework_id) FROM stdin;
\.


--
-- Name: concurrencies_id_seq; Type: SEQUENCE SET; Schema: before; Owner: postgres
--

SELECT pg_catalog.setval('before.concurrencies_id_seq', 1, false);


--
-- Name: frameworks_id_seq; Type: SEQUENCE SET; Schema: before; Owner: postgres
--

SELECT pg_catalog.setval('before.frameworks_id_seq', 1, false);


--
-- Name: keys_id_seq; Type: SEQUENCE SET; Schema: before; Owner: postgres
--

SELECT pg_catalog.setval('before.keys_id_seq', 1, false);


--
-- Name: languages_id_seq; Type: SEQUENCE SET; Schema: before; Owner: postgres
--

SELECT pg_catalog.setval('before.languages_id_seq', 1, false);


--
-- Name: values_id_seq; Type: SEQUENCE SET; Schema: before; Owner: postgres
--

SELECT pg_catalog.setval('before.values_id_seq', 1, false);


--
-- Name: ar_internal_metadata ar_internal_metadata_pkey; Type: CONSTRAINT; Schema: before; Owner: postgres
--

ALTER TABLE ONLY before.ar_internal_metadata
    ADD CONSTRAINT ar_internal_metadata_pkey PRIMARY KEY (key);


--
-- Name: concurrencies concurrencies_pkey; Type: CONSTRAINT; Schema: before; Owner: postgres
--

ALTER TABLE ONLY before.concurrencies
    ADD CONSTRAINT concurrencies_pkey PRIMARY KEY (id);


--
-- Name: frameworks frameworks_pkey; Type: CONSTRAINT; Schema: before; Owner: postgres
--

ALTER TABLE ONLY before.frameworks
    ADD CONSTRAINT frameworks_pkey PRIMARY KEY (id);


--
-- Name: keys keys_pkey; Type: CONSTRAINT; Schema: before; Owner: postgres
--

ALTER TABLE ONLY before.keys
    ADD CONSTRAINT keys_pkey PRIMARY KEY (id);


--
-- Name: languages languages_pkey; Type: CONSTRAINT; Schema: before; Owner: postgres
--

ALTER TABLE ONLY before.languages
    ADD CONSTRAINT languages_pkey PRIMARY KEY (id);


--
-- Name: schema_migrations schema_migrations_pkey; Type: CONSTRAINT; Schema: before; Owner: postgres
--

ALTER TABLE ONLY before.schema_migrations
    ADD CONSTRAINT schema_migrations_pkey PRIMARY KEY (version);


--
-- Name: values values_pkey; Type: CONSTRAINT; Schema: before; Owner: postgres
--

ALTER TABLE ONLY before."values"
    ADD CONSTRAINT values_pkey PRIMARY KEY (id);


--
-- Name: index_concurrencies_on_level; Type: INDEX; Schema: before; Owner: postgres
--

CREATE UNIQUE INDEX index_concurrencies_on_level ON before.concurrencies USING btree (level);


--
-- Name: index_frameworks_on_language_id; Type: INDEX; Schema: before; Owner: postgres
--

CREATE INDEX index_frameworks_on_language_id ON before.frameworks USING btree (language_id);


--
-- Name: index_frameworks_on_language_id_and_label; Type: INDEX; Schema: before; Owner: postgres
--

CREATE UNIQUE INDEX index_frameworks_on_language_id_and_label ON before.frameworks USING btree (language_id, label);


--
-- Name: index_keys_on_label; Type: INDEX; Schema: before; Owner: postgres
--

CREATE UNIQUE INDEX index_keys_on_label ON before.keys USING btree (label);


--
-- Name: index_languages_on_label; Type: INDEX; Schema: before; Owner: postgres
--

CREATE UNIQUE INDEX index_languages_on_label ON before.languages USING btree (label);


--
-- Name: index_metrics_on_concurrency_id; Type: INDEX; Schema: before; Owner: postgres
--

CREATE INDEX index_metrics_on_concurrency_id ON before.metrics USING btree (concurrency_id);


--
-- Name: index_metrics_on_framework_id; Type: INDEX; Schema: before; Owner: postgres
--

CREATE INDEX index_metrics_on_framework_id ON before.metrics USING btree (framework_id);


--
-- Name: index_metrics_on_value_id; Type: INDEX; Schema: before; Owner: postgres
--

CREATE INDEX index_metrics_on_value_id ON before.metrics USING btree (value_id);


--
-- Name: index_values_on_key_id; Type: INDEX; Schema: before; Owner: postgres
--

CREATE INDEX index_values_on_key_id ON before."values" USING btree (key_id);


--
-- Name: index_writable_on_framework_id; Type: INDEX; Schema: before; Owner: postgres
--

CREATE INDEX index_writable_on_framework_id ON before.writable USING btree (framework_id);


--
-- Name: index_writable_on_language_id; Type: INDEX; Schema: before; Owner: postgres
--

CREATE INDEX index_writable_on_language_id ON before.writable USING btree (language_id);


--
-- PostgreSQL database dump complete
--