2
-- PostgreSQL database dump
5
SET client_encoding = 'UTF8';
6
SET standard_conforming_strings = off;
7
SET check_function_bodies = false;
8
SET client_min_messages = warning;
9
SET escape_string_warning = off;
12
-- Name: SCHEMA public; Type: COMMENT; Schema: -; Owner: postgres
15
COMMENT ON SCHEMA public IS 'Standard public schema';
19
-- Name: plpgsql; Type: PROCEDURAL LANGUAGE; Schema: -; Owner: postgres
22
CREATE PROCEDURAL LANGUAGE plpgsql;
25
SET search_path = public, pg_catalog;
27
SET default_tablespace = '';
29
SET default_with_oids = false;
32
-- Name: test_table; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
35
CREATE TABLE test_table (
37
date_deleted timestamp without time zone
41
ALTER TABLE public.test_table OWNER TO postgres;
44
-- Name: test_table_deleted; Type: INDEX; Schema: public; Owner: postgres; Tablespace:
47
CREATE INDEX test_table_deleted ON test_table USING btree (date_deleted) WHERE (date_deleted IS NULL);
51
-- Name: public; Type: ACL; Schema: -; Owner: postgres
54
REVOKE ALL ON SCHEMA public FROM PUBLIC;
55
REVOKE ALL ON SCHEMA public FROM postgres;
56
GRANT ALL ON SCHEMA public TO postgres;
57
GRANT ALL ON SCHEMA public TO PUBLIC;
61
-- PostgreSQL database dump complete