--
-- openGauss database dump
--

SET statement_timeout = 0;
SET xmloption = content;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SET check_function_bodies = false;
SET session_replication_role = replica;
SET client_min_messages = warning;
SET enable_dump_trigger_definer = on;

--
-- Name: BEHAVIORCOMPAT; Type: BEHAVIORCOMPAT; Schema: -; Owner: 
--

SET behavior_compat_options = '';


--
-- Name: LENGTHSEMANTICS; Type: LENGTHSEMANTICS; Schema: -; Owner: 
--

SET nls_length_semantics = 'byte';


SET search_path = "public";

SET default_tablespace = '';

SET default_with_oids = false;

--
-- Name: test1; Type: TABLE; Schema: public; Owner: gauss; Tablespace: 
--

CREATE TABLE "test1" (
    "a" integer,
    "b" text
)
WITH (orientation=row, compression=no);


ALTER TABLE "public"."test1" OWNER TO "gauss";

--
-- Data for Name: test1; Type: TABLE DATA; Schema: public; Owner: gauss
--

COPY public."test1" ("a", "b") FROM stdin;
1	one
2	two
\.
;

--
-- Name: mypub; Type: PUBLICATION; Schema: -; Owner: gauss
--

CREATE PUBLICATION "mypub" FOR ALL TABLES WITH (publish = 'insert, update, delete, truncate',ddl = 'all');


ALTER PUBLICATION "mypub" OWNER TO "gauss";

--
-- Name: public; Type: ACL; Schema: -; Owner: gauss
--

REVOKE ALL ON SCHEMA "public" FROM PUBLIC;
REVOKE ALL ON SCHEMA "public" FROM "gauss";
GRANT CREATE,USAGE ON SCHEMA "public" TO "gauss";
GRANT USAGE ON SCHEMA "public" TO PUBLIC;


--
-- openGauss database dump complete
--