--
-- PostgreSQL database dump
--

SET client_encoding = 'UTF8';
SET standard_conforming_strings = off;
SET check_function_bodies = false;
SET client_min_messages = warning;
SET escape_string_warning = off;

SET search_path = public, pg_catalog;

SET default_tablespace = '';

SET default_with_oids = false;

--
-- Name: schueler; Type: TABLE; Schema: public; Owner: gxx; Tablespace:
--

CREATE TABLE schueler (
    nr integer NOT NULL,
    vorname character varying(20),
    nachname character varying(30),
    klasse character varying(3)
);


-- ALTER TABLE public.schueler OWNER TO gxx;

--
-- Data for Name: schueler; Type: TABLE DATA; Schema: public; Owner: gxx
--

INSERT INTO schueler VALUES (1, 'Fritz', 'Schmitt', '10b');
INSERT INTO schueler VALUES (2, 'Paula', 'Frei', '10a');
INSERT INTO schueler VALUES (3, 'Markus', 'Frei', '7c');
INSERT INTO schueler VALUES (4, 'Julia', 'Schmid', '9d');
INSERT INTO schueler VALUES (5, 'Sigrid', 'Ammer', '8a');
INSERT INTO schueler VALUES (6, 'Boris', 'Anthoff', '10a');
INSERT INTO schueler VALUES (7, 'Susanne', 'Aumann', '10c');
INSERT INTO schueler VALUES (8, 'Josip', 'Azalea', '6e');
INSERT INTO schueler VALUES (9, 'Franziska', 'Bär', '7b');
INSERT INTO schueler VALUES (10, 'Dominik', 'Bauer', '9a');
INSERT INTO schueler VALUES (11, 'Kevin', 'Bloch', '9a');
INSERT INTO schueler VALUES (12, 'Sofie', 'Boswald', '10d');


--
-- Name: schueler_pkey; Type: CONSTRAINT; Schema: public; Owner: gxx; Tablespace:
--

ALTER TABLE ONLY schueler
    ADD CONSTRAINT schueler_pkey PRIMARY KEY (nr);


--
-- PostgreSQL database dump complete
--