text: --
  -- PostgreSQL database dump
  --
  
  -- Dumped from database version 9.5.14
  -- Dumped by pg_dump version 9.5.14
  
  SET statement_timeout = 0;
  SET lock_timeout = 0;
  SET client_encoding = 'UTF8';
  SET standard_conforming_strings = on;
  SELECT pg_catalog.set_config('search_path', '', false);
  SET check_function_bodies = false;
  SET client_min_messages = warning;
  SET row_security = off;
  
  
  ALTER TABLE
      IF EXISTS ONLY public.drinkingwatersource
      DROP CONSTRAINT
          IF EXISTS drinkingwatersource_pkey;
  DROP TABLE IF EXISTS public.drinkingwatersource;
  
  
  SET default_tablespace = '';
  
  SET default_with_oids = false;
  
  --
  -- Name: religion; Type: TABLE; Schema: public; Owner: wazimap_np
  --
  
  CREATE TABLE public.drinkingwatersource
  (
      geo_level     character varying(15)  NOT NULL,
      geo_code      character varying(10)  NOT NULL,
      "drinking water source" character varying(128) NOT NULL,
      total         integer                NOT NULL
  );
  
  
  ALTER TABLE public.drinkingwatersource
      OWNER TO wazimap_np;
  
  --
  -- Data for Name: religion; Type: TABLE DATA; Schema: public; Owner: wazimap_np
  --
  
  \copy public.drinkingwatersource ("drinking water source",total,geo_code,geo_level) FROM 'sql/csv/number-of-households-by-source-of-drinking-water.csv' DELIMITER ',' CSV HEADER;
  
  --
  -- Name: religion_pkey; Type: CONSTRAINT; Schema: public; Owner: wazimap_np
  --
  
  ALTER TABLE ONLY public.drinkingwatersource
      ADD CONSTRAINT drinkingwatersource_pkey PRIMARY KEY (geo_level, geo_code, "drinking water source");
  
  
  --
  -- PostgreSQL database dump complete
  --
  