2
-- PostgreSQL database dump
5
SET client_encoding = 'UTF8';
6
SET check_function_bodies = false;
7
SET client_min_messages = warning;
10
-- Name: SCHEMA public; Type: COMMENT; Schema: -; Owner: postgres
13
COMMENT ON SCHEMA public IS 'Standard public schema';
16
SET search_path = public, pg_catalog;
18
SET default_tablespace = '';
20
SET default_with_oids = false;
23
-- Name: testtable; Type: TABLE; Schema: public; Owner: fordfrog; Tablespace:
26
CREATE TABLE testtable (
29
field3 character varying(150) DEFAULT 'none'::character varying,
30
field4 double precision,
31
"full" timestamp with time zone DEFAULT '2006-11-10 00:00:00+01'::timestamp with time zone NOT NULL,
32
CONSTRAINT field4check CHECK (((field4 > (-5.0)::double precision) AND (field4 < (5.0)::double precision)))
34
ALTER TABLE ONLY testtable ALTER COLUMN "full" SET STATISTICS 200;
37
ALTER TABLE public.testtable OWNER TO fordfrog;
40
-- Name: testindex; Type: INDEX; Schema: public; Owner: fordfrog; Tablespace:
43
CREATE INDEX testindex ON testtable USING btree (field3);
47
-- Name: public; Type: ACL; Schema: -; Owner: postgres
50
REVOKE ALL ON SCHEMA public FROM PUBLIC;
51
REVOKE ALL ON SCHEMA public FROM postgres;
52
GRANT ALL ON SCHEMA public TO postgres;
53
GRANT ALL ON SCHEMA public TO PUBLIC;
57
-- PostgreSQL database dump complete