Wed Jan 5 18:10:38 PST 2005
- Previous message: [Slony1-general] Re: Add an --execute option for altperl scripts?
- Next message: [Slony1-general] schema restore problem
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Skipped content of type multipart/alternative-------------- next part --------------
--
-- PostgreSQL database dump
--
SET client_encoding = 'SQL_ASCII';
SET check_function_bodies = false;
SET SESSION AUTHORIZATION 'postgres';
SET search_path = public, pg_catalog;
--
-- TOC entry 10 (OID 39618267)
-- Name: plpgsql_call_handler(); Type: FUNC PROCEDURAL LANGUAGE; Schema: public; Owner: postgres
--
CREATE FUNCTION plpgsql_call_handler() RETURNS language_handler
AS '$libdir/plpgsql', 'plpgsql_call_handler'
LANGUAGE c;
SET SESSION AUTHORIZATION DEFAULT;
--
-- TOC entry 9 (OID 39618268)
-- Name: plpgsql; Type: PROCEDURAL LANGUAGE; Schema: public; Owner:
--
CREATE TRUSTED PROCEDURAL LANGUAGE plpgsql HANDLER plpgsql_call_handler;
SET SESSION AUTHORIZATION 'postgres';
--
-- TOC entry 4 (OID 2200)
-- Name: public; Type: ACL; Schema: -; Owner: postgres
--
REVOKE ALL ON SCHEMA public FROM PUBLIC;
GRANT ALL ON SCHEMA public TO PUBLIC;
SET SESSION AUTHORIZATION 'postgres';
--
-- TOC entry 11 (OID 11950757)
-- Name: =; Type: OPERATOR; Schema: public; Owner: postgres
--
CREATE OPERATOR = (
PROCEDURE = xideq,
LEFTARG = xid,
RIGHTARG = xid,
COMMUTATOR = pg_catalog.=,
NEGATOR = <>,
RESTRICT = eqsel,
JOIN = eqjoinsel
);
--
-- TOC entry 5 (OID 39618294)
-- Name: newt2; Type: TABLE; Schema: public; Owner: postgres
--
CREATE TABLE newt2 (
id integer NOT NULL,
name character varying(30),
lname character varying(30),
city character varying(20)
);
--
-- TOC entry 6 (OID 39619019)
-- Name: newt; Type: TABLE; Schema: public; Owner: postgres
--
CREATE TABLE newt (
id integer NOT NULL,
descr character varying(34)
);
--
-- TOC entry 7 (OID 39618296)
-- Name: newt2_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--
ALTER TABLE ONLY newt2
ADD CONSTRAINT newt2_pkey PRIMARY KEY (id);
--
-- TOC entry 8 (OID 39619021)
-- Name: newt_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--
ALTER TABLE ONLY newt
ADD CONSTRAINT newt_pkey PRIMARY KEY (id);
--
-- TOC entry 3 (OID 2200)
-- Name: SCHEMA public; Type: COMMENT; Schema: -; Owner: postgres
--
COMMENT ON SCHEMA public IS 'Standard public schema';
- Previous message: [Slony1-general] Re: Add an --execute option for altperl scripts?
- Next message: [Slony1-general] schema restore problem
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list