Schéma databáze – začátek.
2 -- PostgreSQL database dump
5 -- Started on 2010-01-16 02:43:00 CET
7 SET statement_timeout = 0;
8 SET client_encoding = 'UTF8';
9 SET standard_conforming_strings = off;
10 SET check_function_bodies = false;
11 SET client_min_messages = warning;
12 SET escape_string_warning = off;
15 -- TOC entry 10 (class 2615 OID 35015)
16 -- Name: nekurak; Type: SCHEMA; Schema: -; Owner: nekurak
19 CREATE SCHEMA nekurak;
22 ALTER SCHEMA nekurak OWNER TO nekurak;
24 SET search_path = nekurak, pg_catalog;
27 -- TOC entry 1568 (class 1259 OID 35019)
29 -- Name: podnik_seq; Type: SEQUENCE; Schema: nekurak; Owner: nekurak
32 CREATE SEQUENCE podnik_seq
39 ALTER TABLE nekurak.podnik_seq OWNER TO nekurak;
42 -- TOC entry 1847 (class 0 OID 0)
44 -- Name: podnik_seq; Type: SEQUENCE SET; Schema: nekurak; Owner: nekurak
47 SELECT pg_catalog.setval('podnik_seq', 3, true);
50 SET default_tablespace = '';
52 SET default_with_oids = false;
55 -- TOC entry 1569 (class 1259 OID 35021)
56 -- Dependencies: 1840 1841 10
57 -- Name: podnik; Type: TABLE; Schema: nekurak; Owner: nekurak; Tablespace:
61 id integer DEFAULT nextval('podnik_seq'::regclass) NOT NULL,
62 nazev character varying(255) NOT NULL,
63 datum timestamp with time zone DEFAULT now()
67 ALTER TABLE nekurak.podnik OWNER TO nekurak;
70 -- TOC entry 1844 (class 0 OID 35021)
72 -- Data for Name: podnik; Type: TABLE DATA; Schema: nekurak; Owner: nekurak
75 COPY podnik (id, nazev, datum) FROM stdin;
76 1 Na Kovárně 2010-01-16 02:40:12.271326+01
77 2 U přátelského potkana 2010-01-16 02:40:43.326281+01
78 3 Na Růžku 2010-01-16 02:40:48.104577+01
83 -- TOC entry 1843 (class 2606 OID 35027)
84 -- Dependencies: 1569 1569
85 -- Name: podnik_pk; Type: CONSTRAINT; Schema: nekurak; Owner: nekurak; Tablespace:
88 ALTER TABLE ONLY podnik
89 ADD CONSTRAINT podnik_pk PRIMARY KEY (id);
92 -- Completed on 2010-01-16 02:43:01 CET
95 -- PostgreSQL database dump complete