--
--

SELECT pg_catalog.set_config('search_path', '', false);

--
-- Name: plpgsql; Type: EXTENSION; Schema: -; Owner: 
--

CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;


--
-- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner: 
--

COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';


--
-- Name: postgis; Type: EXTENSION; Schema: -; Owner: 
--

CREATE EXTENSION IF NOT EXISTS postgis WITH SCHEMA public;


--
-- Name: EXTENSION postgis; Type: COMMENT; Schema: -; Owner: 
--

COMMENT ON EXTENSION postgis IS 'PostGIS geometry, geography, and raster spatial types and functions';




--
-- Name: teste; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE public.teste (
    registro integer NOT NULL,
    talhao public.geometry,
    imagem bytea,
    nometalhao character varying(50)
);


ALTER TABLE public.teste OWNER TO postgres;

--
-- Name: myunion; Type: VIEW; Schema: public; Owner: postgres
--

CREATE VIEW public.myunion AS
 SELECT public.st_union(teste.talhao) AS st_union
   FROM public.teste
  WHERE (teste.registro = 1);


ALTER TABLE public.myunion OWNER TO postgres;

--
-- Name: teste_registro_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.teste_registro_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.teste_registro_seq OWNER TO postgres;

--
-- Name: teste_registro_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.teste_registro_seq OWNED BY public.teste.registro;


--
-- Name: registro; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.teste ALTER COLUMN registro SET DEFAULT nextval('public.teste_registro_seq'::regclass);


--
-- Name: 17879; Type: BLOB; Schema: -; Owner: postgres
--

SELECT pg_catalog.lo_create('17879');


ALTER LARGE OBJECT 17879 OWNER TO postgres;

--
-- Data for Name: spatial_ref_sys; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.spatial_ref_sys  FROM stdin;
\.


--
-- Data for Name: teste; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.teste (registro, talhao, imagem, nometalhao) FROM stdin;
24	010300000001000000050000001A303F8405C046C03602A110AF3027C0CDC4868CFFBF46C0A68C4B574B3527C0A2AF4AC050C246C051A48A0C133427C06B44FAD058C246C03C22C2577A2F27C01A303F8405C046C03602A110AF3027C0	\\x[BLOB]	2965
22	010300000001000000050000001A303F8405C046C03602A110AF3027C0CDC4868CFFBF46C0A68C4B574B3527C0A2AF4AC050C246C051A48A0C133427C06B44FAD058C246C03C22C2577A2F27C01A303F8405C046C03602A110AF3027C0	\\x[BLOB]	2965
23	010300000001000000050000001A303F8405C046C03602A110AF3027C0CDC4868CFFBF46C0A68C4B574B3527C0A2AF4AC050C246C051A48A0C133427C06B44FAD058C246C03C22C2577A2F27C01A303F8405C046C03602A110AF3027C0	\\x[BLOB]	2965
25	010300000001000000050000001A303F8405C046C03602A110AF3027C0CDC4868CFFBF46C0A68C4B574B3527C0A2AF4AC050C246C051A48A0C133427C06B44FAD058C246C03C22C2577A2F27C01A303F8405C046C03602A110AF3027C0	\\x[BLOB]	2965
26	010300000001000000050000001A303F8405C046C03602A110AF3027C0CDC4868CFFBF46C0A68C4B574B3527C0A2AF4AC050C246C051A48A0C133427C06B44FAD058C246C03C22C2577A2F27C01A303F8405C046C03602A110AF3027C0	\\x[BLOB]	2965
27	010300000001000000050000001A303F8405C046C03602A110AF3027C0CDC4868CFFBF46C0A68C4B574B3527C0A2AF4AC050C246C051A48A0C133427C06B44FAD058C246C03C22C2577A2F27C01A303F8405C046C03602A110AF3027C0	\\x[BLOB]	2965
28	010300000001000000050000001A303F8405C046C03602A110AF3027C0CDC4868CFFBF46C0A68C4B574B3527C0A2AF4AC050C246C051A48A0C133427C06B44FAD058C246C03C22C2577A2F27C01A303F8405C046C03602A110AF3027C0	\\x[BLOB]	2965
\.


--
-- Name: teste_registro_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.teste_registro_seq', 28, true);


--
-- Data for Name: BLOBS; Type: BLOBS; Schema: -; Owner: 
--

BEGIN;

SELECT pg_catalog.lo_open('17879', 131072);
SELECT pg_catalog.lowrite(0, '\x[BLOB]');
SELECT pg_catalog.lo_close(0);

COMMIT;

--
-- Name: SCHEMA public; Type: ACL; Schema: -; Owner: postgres
--

REVOKE ALL ON SCHEMA public FROM PUBLIC;
REVOKE ALL ON SCHEMA public FROM postgres;
GRANT ALL ON SCHEMA public TO postgres;
GRANT ALL ON SCHEMA public TO PUBLIC;


--
--

