wetspot.blogg.se

clients ADD CONSTRAINT clients_pkey PRIMARY KEY ( id ) - PostgreSQL database dump complete. setval ( 'public.clients_id_seq', 2, true ) - Name: clients clients_pkey Type: CONSTRAINT Schema: public Owner: postgres - ALTER TABLE ONLY public. Name: clients_id_seq Type: SEQUENCE SET Schema: public Owner: postgres - SELECT pg_catalog. clients ( id, name ) FROM stdin 1 Client 1 2 Client 2 \. clients ALTER COLUMN id SET DEFAULT nextval ( 'public.clients_id_seq' :: regclass ) - Data for Name: clients Type: TABLE DATA Schema: public Owner: postgres - COPY public. id - Name: clients id Type: DEFAULT Schema: public Owner: postgres - ALTER TABLE ONLY public. clients_id_seq OWNER TO postgres - Name: clients_id_seq Type: SEQUENCE OWNED BY Schema: public Owner: postgres - ALTER SEQUENCE public. clients_id_seq AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1 ALTER TABLE public. clients OWNER TO postgres - Name: clients_id_seq Type: SEQUENCE Schema: public Owner: postgres - CREATE SEQUENCE public. clients ( id integer NOT NULL, name character varying ( 150 ) NOT NULL ) ALTER TABLE public. 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_with_oids = false - Name: clients Type: TABLE Schema: public Owner: postgres - CREATE TABLE public. set_config ( 'search_path', '', false ) SET check_function_bodies = false SET xmloption = content SET client_min_messages = warning SET row_security = off - Name: my_db Type: DATABASE Schema: - Owner: postgres - CREATE DATABASE my_db WITH TEMPLATE = template0 ENCODING = 'UTF8' LC_COLLATE = 'en_US.utf8' LC_CTYPE = 'en_US.utf8' ALTER DATABASE my_db OWNER TO postgres \ connect my_db 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. Imagine that we have the following Postgresql database dump: - PostgreSQL database dump - Dumped from database version 11.5 - Dumped by pg_dump version 11.3 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.