data.sql

application/sql

Download

--
-- PostgreSQL database dump
--

-- Dumped from database version 14devel
-- Dumped by pg_dump version 14devel

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: flights; Type: TABLE; Schema: public; Owner: pavel
--

CREATE TABLE public.flights (
    departure character(20),
    arrival character(20),
    carrier character(15),
    flight_number character(5),
    price integer
);


ALTER TABLE public.flights OWNER TO pavel;

--
-- Data for Name: flights; Type: TABLE DATA; Schema: public; Owner: pavel
--

COPY public.flights (departure, arrival, carrier, flight_number, price) FROM stdin;
New York            	Paris               	Atlantic       	234  	400
Chicago             	Miami               	NA Air         	2334 	300
New York            	London              	Atlantic       	5473 	350
London              	Athens              	Mediterranean  	247  	340
Athens              	Nicosia             	Mediterranean  	2356 	280
Paris               	Madrid              	Euro Air       	3256 	380
Paris               	Cairo               	Euro Air       	63   	480
Chicago             	Frankfurt           	Atlantic       	37   	480
Frankfurt           	Moscow              	Asia Air       	2337 	580
Frankfurt           	Beijing             	Asia Air       	77   	480
Moscow              	Tokyo               	Asia Air       	437  	680
Frankfurt           	Vienna              	Euro Air       	59   	200
Paris               	Rome                	Euro Air       	534  	340
Miami               	Lima                	SA Air         	5234 	530
New York            	Los Angeles         	NA Air         	84   	330
Los Angeles         	Tokyo               	Pacific Air    	824  	530
Tokyo               	Hawaii              	Asia Air       	94   	330
Washington          	Toronto             	NA Air         	104  	250
Cairo               	Paris               	Euro Air       	1134 	440
Cairo               	Paris               	Atlantic       	1134 	440
\.


--
-- PostgreSQL database dump complete
--