SQL GREAT

--
-- PostgreSQL database dump
--

-- Dumped from database version 9.2.3
-- Dumped by pg_dump version 9.2.3
-- Started on 2014-05-26 16:42:11

SET statement_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SET check_function_bodies = false;
SET client_min_messages = warning;

--
-- TOC entry 176 (class 3079 OID 11727)
-- Name: plpgsql; Type: EXTENSION; Schema: -; Owner:
--

CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;

--
-- TOC entry 1977 (class 0 OID 0)
-- Dependencies: 176
-- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner:
--

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

SET search_path = public, pg_catalog;

SET default_tablespace = '';

SET default_with_oids = false;

--
-- TOC entry 168 (class 1259 OID 16640)
-- Name: cidade; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
--

CREATE TABLE cidade ( cod_cidade integer NOT NULL, cidade character varying(60)
);

ALTER TABLE public.cidade OWNER TO postgres;

--
-- TOC entry 169 (class 1259 OID 16643)
-- Name: departamento; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
--

CREATE TABLE departamento ( cod_departamento integer NOT NULL, departamento character varying(60), datainicio timestamp with time zone, cod_empregado integer, cod_cidade integer
);

ALTER TABLE public.departamento OWNER TO postgres;

--
-- TOC entry 170 (class 1259 OID 16646)
-- Name: dependente; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
--

CREATE TABLE dependente ( cod_empregado integer NOT NULL, cod_dependente integer NOT NULL, nomedep character varying(60), sexodep character varying(1), datanascdep timestamp with time zone, tipodep character varying(1)
);

ALTER TABLE public.dependente OWNER TO postgres;

--
-- TOC entry 171 (class 1259 OID 16649)
-- Name: empregado; Type: TABLE;