You cannot select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
106 lines
2.5 KiB
SQL
106 lines
2.5 KiB
SQL
--
|
|
-- PostgreSQL database dump
|
|
--
|
|
|
|
-- Dumped from database version 13.9 (Debian 13.9-0+deb11u1)
|
|
-- Dumped by pg_dump version 13.9 (Debian 13.9-0+deb11u1)
|
|
|
|
SET statement_timeout = 0;
|
|
SET lock_timeout = 0;
|
|
SET idle_in_transaction_session_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 xmloption = content;
|
|
SET client_min_messages = warning;
|
|
SET row_security = off;
|
|
|
|
SET default_tablespace = '';
|
|
|
|
SET default_table_access_method = heap;
|
|
|
|
--
|
|
-- Name: horses; Type: TABLE; Schema: public; Owner: jrisacher
|
|
--
|
|
|
|
CREATE TABLE public.horses (
|
|
id integer NOT NULL,
|
|
name character varying(30),
|
|
farm character varying(30),
|
|
breed character varying(50),
|
|
prize integer,
|
|
date_won date
|
|
);
|
|
|
|
|
|
ALTER TABLE public.horses OWNER TO jrisacher;
|
|
|
|
--
|
|
-- Name: horses_id_seq; Type: SEQUENCE; Schema: public; Owner: jrisacher
|
|
--
|
|
|
|
CREATE SEQUENCE public.horses_id_seq
|
|
AS integer
|
|
START WITH 1
|
|
INCREMENT BY 1
|
|
NO MINVALUE
|
|
NO MAXVALUE
|
|
CACHE 1;
|
|
|
|
|
|
ALTER TABLE public.horses_id_seq OWNER TO jrisacher;
|
|
|
|
--
|
|
-- Name: horses_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: jrisacher
|
|
--
|
|
|
|
ALTER SEQUENCE public.horses_id_seq OWNED BY public.horses.id;
|
|
|
|
|
|
--
|
|
-- Name: horses id; Type: DEFAULT; Schema: public; Owner: jrisacher
|
|
--
|
|
|
|
ALTER TABLE ONLY public.horses ALTER COLUMN id SET DEFAULT nextval('public.horses_id_seq'::regclass);
|
|
|
|
|
|
--
|
|
-- Data for Name: horses; Type: TABLE DATA; Schema: public; Owner: jrisacher
|
|
--
|
|
|
|
COPY public.horses (id, name, farm, breed, prize, date_won) FROM stdin;
|
|
1 calypso sleipnir stables thoroughbred 1000 2005-03-12
|
|
2 sunny sleipnir stables thoroughbred 500 2012-07-15
|
|
3 Eevee sleipnir stables paint 300 2020-12-20
|
|
4 wally Shenandoah stables Icelandic horse 300 2020-12-20
|
|
5 calypso sleipnir stables thoroughbred 800 2011-06-23
|
|
6 Inny Burgundy Farm quarer horse 1000 2007-04-04
|
|
7 calypso sleipnir stables thoroughbred 2000 2003-01-13
|
|
8 Eevee sleipnir stables paint 100 2021-03-07
|
|
9 Inny Burgundy Farm quarer horse 200 2008-03-14
|
|
10 wally Shenandoah stables Icelandic horse 400 2021-09-22
|
|
11 Virginia Marithiel Mustang 900 2001-08-17
|
|
\.
|
|
|
|
|
|
--
|
|
-- Name: horses_id_seq; Type: SEQUENCE SET; Schema: public; Owner: jrisacher
|
|
--
|
|
|
|
SELECT pg_catalog.setval('public.horses_id_seq', 11, true);
|
|
|
|
|
|
--
|
|
-- Name: horses horses_pkey; Type: CONSTRAINT; Schema: public; Owner: jrisacher
|
|
--
|
|
|
|
ALTER TABLE ONLY public.horses
|
|
ADD CONSTRAINT horses_pkey PRIMARY KEY (id);
|
|
|
|
|
|
--
|
|
-- PostgreSQL database dump complete
|
|
--
|
|
|