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 164211

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 Schema public Owner postgres Tablespace
--

CREATE TABLE empregado (