text: --
  -- PostgreSQL database dump
  --
  
  SET statement_timeout = 0;
  SET lock_timeout = 0;
  SET client_encoding = 'UTF8';
  SET standard_conforming_strings = on;
  SET check_function_bodies = false;
  SET client_min_messages = warning;
  
  --
  -- 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';
  
  
  SET search_path = public, pg_catalog;
  
  SET default_tablespace = '';
  
  SET default_with_oids = false;
  
  --
  -- Name: clients; Type: TABLE; Schema: public; Owner: tanner; Tablespace: 
  --
  
  CREATE TABLE clients (
      id integer NOT NULL,
      c_name character varying,
      stylist_id integer
  );
  
  
  ALTER TABLE clients OWNER TO tanner;
  
  --
  -- Name: clients_id_seq; Type: SEQUENCE; Schema: public; Owner: tanner
  --
  
  CREATE SEQUENCE clients_id_seq
      START WITH 1
      INCREMENT BY 1
      NO MINVALUE
      NO MAXVALUE
      CACHE 1;
  
  
  ALTER TABLE clients_id_seq OWNER TO tanner;
  
  --
  -- Name: clients_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: tanner
  --
  
  ALTER SEQUENCE clients_id_seq OWNED BY clients.id;
  
  
  --
  -- Name: stylists; Type: TABLE; Schema: public; Owner: tanner; Tablespace: 
  --
  
  CREATE TABLE stylists (
      id integer NOT NULL,
      name character varying
  );
  
  
  ALTER TABLE stylists OWNER TO tanner;
  
  --
  -- Name: stylists_id_seq; Type: SEQUENCE; Schema: public; Owner: tanner
  --
  
  CREATE SEQUENCE stylists_id_seq
      START WITH 1
      INCREMENT BY 1
      NO MINVALUE
      NO MAXVALUE
      CACHE 1;
  
  
  ALTER TABLE stylists_id_seq OWNER TO tanner;
  
  --
  -- Name: stylists_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: tanner
  --
  
  ALTER SEQUENCE stylists_id_seq OWNED BY stylists.id;
  
  
  --
  -- Name: id; Type: DEFAULT; Schema: public; Owner: tanner
  --
  
  ALTER TABLE ONLY clients ALTER COLUMN id SET DEFAULT nextval('clients_id_seq'::regclass);
  
  
  --
  -- Name: id; Type: DEFAULT; Schema: public; Owner: tanner
  --
  
  ALTER TABLE ONLY stylists ALTER COLUMN id SET DEFAULT nextval('stylists_id_seq'::regclass);
  
  
  --
  -- Data for Name: clients; Type: TABLE DATA; Schema: public; Owner: tanner
  --
  
  COPY clients (id, c_name, stylist_id) FROM stdin;
  1	Test2	6
  2	Test2	6
  3	fred	6
  5	howdy	10
  \.
  
  
  --
  -- Name: clients_id_seq; Type: SEQUENCE SET; Schema: public; Owner: tanner
  --
  
  SELECT pg_catalog.setval('clients_id_seq', 27, true);
  
  
  --
  -- Data for Name: stylists; Type: TABLE DATA; Schema: public; Owner: tanner
  --
  
  COPY stylists (id, name) FROM stdin;
  17	test2
  \.
  
  
  --
  -- Name: stylists_id_seq; Type: SEQUENCE SET; Schema: public; Owner: tanner
  --
  
  SELECT pg_catalog.setval('stylists_id_seq', 17, true);
  
  
  --
  -- Name: clients_pkey; Type: CONSTRAINT; Schema: public; Owner: tanner; Tablespace: 
  --
  
  ALTER TABLE ONLY clients
      ADD CONSTRAINT clients_pkey PRIMARY KEY (id);
  
  
  --
  -- Name: stylists_pkey; Type: CONSTRAINT; Schema: public; Owner: tanner; Tablespace: 
  --
  
  ALTER TABLE ONLY stylists
      ADD CONSTRAINT stylists_pkey PRIMARY KEY (id);
  
  
  --
  -- Name: public; Type: ACL; Schema: -; Owner: tanner
  --
  
  REVOKE ALL ON SCHEMA public FROM PUBLIC;
  REVOKE ALL ON SCHEMA public FROM tanner;
  GRANT ALL ON SCHEMA public TO tanner;
  GRANT ALL ON SCHEMA public TO PUBLIC;
  
  
  --
  -- PostgreSQL database dump complete
  --
  
  