sample db data

dbooks.sql

--
-- PostgreSQL database dump
--

-- Dumped from database version 9.1.3
-- Dumped by pg_dump version 9.1.3
-- Started on 2012-05-26 21:21:34

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 163 (class 3079 OID 11639)
-- Name: plpgsql; Type: EXTENSION; Schema: -; Owner: 
--

CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;


--
-- TOC entry 1859 (class 0 OID 0)
-- Dependencies: 163
-- 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 161 (class 1259 OID 16458)
-- Dependencies: 6
-- Name: dbooks; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE dbooks (
    id integer NOT NULL,
    title character varying,
    author_editor character varying,
    date_of_publication character varying,
    publisher character varying,
    key_words character varying,
    notes character varying,
    valuation character varying,
    purchase_price character varying
);


ALTER TABLE public.dbooks OWNER TO postgres;

--
-- TOC entry 162 (class 1259 OID 16464)
-- Dependencies: 161 6
-- Name: dbooks_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE dbooks_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.dbooks_id_seq OWNER TO postgres;

--
-- TOC entry 1860 (class 0 OID 0)
-- Dependencies: 162
-- Name: dbooks_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE dbooks_id_seq OWNED BY dbooks.id;


--
-- TOC entry 1861 (class 0 OID 0)
-- Dependencies: 162
-- Name: dbooks_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('dbooks_id_seq', 18, true);


--
-- TOC entry 1849 (class 2604 OID 16466)
-- Dependencies: 162 161
-- Name: id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY dbooks ALTER COLUMN id SET DEFAULT nextval('dbooks_id_seq'::regclass);


--
-- TOC entry 1853 (class 0 OID 16458)
-- Dependencies: 161
-- Data for Name: dbooks; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY dbooks (id, title, author_editor, date_of_publication, publisher, key_words, notes, valuation, purchase_price) FROM stdin;
1	African agricultural research and technological development (A)	Pickering, Donald C	1987		proceedings of a high-level meeting in feldafing, federal republic of Germany, September 24-27, 1987	amazon: 08/04/08 Category: Agriculture (A)	14.00	12.00
2	Selected references on management of white-tailed deer 1910 to 1966 ((B))	Hosley, N.W.	1968	United States Department of the Interior, Fish and Wildlife Service, Bureau of Sport Fisheries and Wildlife		Category: Wildlife (L)	4.00	-
3	Game inventory of Alabama ((B))	Barkalow, Frederick S., Jr.	1949	Alabama Department of Conservation-Gam, Fish and Seafoods Division		Category: Wildlife (L)	5.00	-
4	National wildlife research center: highlights report fiscal year 2000 ((B))	U.S. Department of Agriculture	2001	United States Department of Agriculture, Animal and Plant Health Inspection Service, Miscellaneous Publication No. 1568		Category: Wildlife (L)	6.00	-
5	Age determination of wildlife: a bibliography ((B))	Madsen, Ruth M.	1967	United States Department of the Interior, Bibliography No. 2		Category: Wildlife (L)	3.00	-
6	Sex, evolution and behavior (A)	Daly, Martin, Margo Wilson	1978	Duxbury Press		amazon: 5/26/09 Category: Miscellaneous NR Subject (M)	4.00	5.00
7	Riparian area management: inventory and monitoring of riparian areas (B)	Myers, Lewis H.	1989	United States Department of the Interior, Bureau of Land Management, Technical Reference TR 1737-3		Category: Wetlands and water (W)	4.00	-
8	Assessment of effects of altered stream flow characteristics on fish and wildlife: part a: Rocky Mountains and Pacific Northwest ((B))	Nelson, W., G. Horak, M. Lewis, J. Colt	1976	United States Department of the Interior: Fish and Wildlife Service	stream flow, fish, wildlife, water	Category: Water & Wetlands (W)	0.50	-
9	Assessment of effects of altered stream flow characteristics on fish and wildlife: part b: California ((B))	Hazel, Charles, Steven Herrera, Harry Rectenwald, Jonathan Ives	1976	United States Department of the Interior: Fish and Wildlife Service		Category: Water & Wetlands (W)	.50	-
10	Rocky Mountain timber situation, 1970 ((B))	Green, Alan W., Theodore S. Setzer	1974	United States Department of Agriculture, Forest Service, Resource Bulletin INT-10		Category: Forest, Wilderness and Fire (F)	-	5.00
11	!test					!maybe		
13	! *`-=[];',./~@#$%^&()_+{}|:"<>?\\	! *`-=[];',./~@#$%^&()_+{}|:"<>?\\	! *`-=[];',./~@#$%^&()_+{}|:"<>?\\	! *`-=[];',./~@#$%^&()_+{}|:"<>?\\	! *`-=[];',./~@#$%^&()_+{}|:"<>?\\	! *`-=[];',./~@#$%^&()_+{}|:"<>?\\	! *`-=[];',./~@#$%^&()_+{}|:"<>?\\	! *`-=[];',./~@#$%^&()_+{}|:"<>?\\
12	!iaa							
14	!ia							
15	!!							
16	z							
17	Ekologie lučních porostů (A)	Rychnovská, Milena, Emilie Balátová-Tuláčková, Blanka Úlehlová, Jaroslav Pelikán|	1985	Academia		amazon 5/22/09 Category: Ecology (Y)	8.00	10.00
18	\\--\\							
\.


--
-- TOC entry 1851 (class 2606 OID 16468)
-- Dependencies: 161 161
-- Name: dbooks_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: 
--

ALTER TABLE ONLY dbooks
    ADD CONSTRAINT dbooks_pkey PRIMARY KEY (id);


--
-- TOC entry 1852 (class 1259 OID 16469)
-- Dependencies: 161
-- Name: title_idx; Type: INDEX; Schema: public; Owner: postgres; Tablespace: 
--

CREATE INDEX title_idx ON dbooks USING btree (title);


--
-- TOC entry 1858 (class 0 OID 0)
-- Dependencies: 6
-- Name: 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;


-- Completed on 2012-05-26 21:21:34

--
-- PostgreSQL database dump complete
--