SQLize Online / PHPize Online  /  SQLtest Online

-- -- PostgreSQL database dump -- -- Dumped from database version 14.2 (Debian 14.2-1.pgdg110+1) -- Dumped by pg_dump version 14.2 (Debian 14.2-1.pgdg110+1) 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: demo; Type: TABLE; Schema: public; Owner: - -- CREATE TABLE public.demo ( id integer NOT NULL, name character varying(200) DEFAULT ''::character varying NOT NULL, hint text DEFAULT ''::text NOT NULL ); -- -- Name: demo_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- CREATE SEQUENCE public.demo_id_seq AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; -- -- Name: demo_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- ALTER SEQUENCE public.demo_id_seq OWNED BY public.demo.id; -- -- Name: trainjoureny; Type: TABLE; Schema: public; Owner: - -- CREATE TABLE public.trainjoureny ( id integer NOT NULL, number character varying(255) NOT NULL, date_time date NOT NULL ); -- -- Name: trainjoureny_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- ALTER TABLE public.trainjoureny ALTER COLUMN id ADD GENERATED ALWAYS AS IDENTITY ( SEQUENCE NAME public.trainjoureny_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1 ); -- -- Name: trainjourenyschema; Type: TABLE; Schema: public; Owner: - -- CREATE TABLE public.trainjourenyschema ( id integer NOT NULL, trainjourenyid integer NOT NULL, capacity integer NOT NULL ); -- -- Name: trainjourenyschema_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- ALTER TABLE public.trainjourenyschema ALTER COLUMN id ADD GENERATED ALWAYS AS IDENTITY ( SEQUENCE NAME public.trainjourenyschema_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1 ); -- -- Name: demo id; Type: DEFAULT; Schema: public; Owner: - -- ALTER TABLE ONLY public.demo ALTER COLUMN id SET DEFAULT nextval('public.demo_id_seq'::regclass); -- -- Name: demo demo_pkey; Type: CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY public.demo ADD CONSTRAINT demo_pkey PRIMARY KEY (id); -- -- Name: trainjoureny trainjoureny_pkey; Type: CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY public.trainjoureny ADD CONSTRAINT trainjoureny_pkey PRIMARY KEY (id); -- -- Name: trainjourenyschema trainjourenyid_const; Type: CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY public.trainjourenyschema ADD CONSTRAINT trainjourenyid_const UNIQUE (trainjourenyid); -- -- Name: trainjourenyschema trainjourenyschema_pkey; Type: CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY public.trainjourenyschema ADD CONSTRAINT trainjourenyschema_pkey PRIMARY KEY (id); -- -- Name: trainjourenyschema trainjourenyschema_trainjourenyid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY public.trainjourenyschema ADD CONSTRAINT trainjourenyschema_trainjourenyid_fkey FOREIGN KEY (trainjourenyid) REFERENCES public.trainjoureny(id); -- -- Name: trainjourenyschema trainjourenyschema_trainjourenyid_fkey1; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY public.trainjourenyschema ADD CONSTRAINT trainjourenyschema_trainjourenyid_fkey1 FOREIGN KEY (trainjourenyid) REFERENCES public.trainjoureny(id); -- -- Name: trainjourenyschema trainjourenyschema_trainjourenyid_fkey2; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY public.trainjourenyschema ADD CONSTRAINT trainjourenyschema_trainjourenyid_fkey2 FOREIGN KEY (trainjourenyid) REFERENCES public.trainjoureny(id); -- -- Name: trainjourenyschema trainjourenyschema_trainjourenyid_fkey3; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY public.trainjourenyschema ADD CONSTRAINT trainjourenyschema_trainjourenyid_fkey3 FOREIGN KEY (trainjourenyid) REFERENCES public.trainjoureny(id); -- -- Name: trainjourenyschema trainjourenyschema_trainjourenyid_fkey4; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY public.trainjourenyschema ADD CONSTRAINT trainjourenyschema_trainjourenyid_fkey4 FOREIGN KEY (trainjourenyid) REFERENCES public.trainjoureny(id); -- -- Name: trainjourenyschema trainjourenyschema_trainjourenyid_fkey5; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY public.trainjourenyschema ADD CONSTRAINT trainjourenyschema_trainjourenyid_fkey5 FOREIGN KEY (trainjourenyid) REFERENCES public.trainjoureny(id); -- -- PostgreSQL database dump complete -- INSERT into public.trainjoureny (id,number,date_time) VALUES (DEFAULT,100,'2019-01-01'),(DEFAULT,128,'2018-02-05'), (DEFAULT,736,'2019-08-07'),(DEFAULT,952,'2020-05-03'),(DEFAULT,105,'2018-08-21'),(DEFAULT,119,'2019-09-21'); INSERT into public.trainjourenyschema (id,trainjourenyid,capacity) VALUES (DEFAULT,2,'10'),(DEFAULT,3,'7'), (DEFAULT,5,'2'),(DEFAULT,1,'7'),(DEFAULT,4,'15'),(DEFAULT,6,'1'); DELETE from public.trainjourenyschema WHERE id = 1; DELETE from public.trainjourenyschema WHERE id = 3; DELETE from public.trainjourenyschema WHERE id = 6; SELECT * FROM public.trainjourenyschema JOIN public.trainjoureny ON trainjoureny.id = trainjourenyschema.trainjourenyid WHERE date_time between '2019-01-01'::date and '2019-12-31'::date;