| From: | Олег Самойлов <splarv(at)ya(dot)ru> |
|---|---|
| To: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | pg_dump and public schema |
| Date: | 2020-03-04 13:42:58 |
| Message-ID: | D6222EE7-B4EE-4529-BE85-745BD4A0EF53@ya.ru |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi all. PostgresQL 12.1. Strange behaviour with pg_dump and absent public schema.
I droped public schema and I work under "username" schema.
=> \dn
List of schemas
Name | Owner
-------+-------
olleg | olleg
(1 row)
Dump now
pg_dump -U postgres -C olleg >dump.sql
--
-- PostgreSQL database dump
--
-- Dumped from database version 12.1
-- Dumped by pg_dump version 12.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;
--
-- Name: olleg; Type: DATABASE; Schema: -; Owner: olleg
--
CREATE DATABASE olleg WITH TEMPLATE = template0 ENCODING = 'UTF8' LC_COLLATE = 'ru_RU.UTF-8' LC_CTYPE = 'ru_RU.UTF-8';
ALTER DATABASE olleg OWNER TO olleg;
\connect olleg
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;
--
-- Name: olleg; Type: SCHEMA; Schema: -; Owner: olleg
--
CREATE SCHEMA olleg;
ALTER SCHEMA olleg OWNER TO olleg;
--
-- PostgreSQL database dump complete
--
recreate DB from the dump:
psql postgres postgres -f dump.sql
And now I see public schema, which must be absent.
psql olleg olleg
=> \dn
List of schemas
Name | Owner
--------+----------
olleg | olleg
public | postgres
(2 rows)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Paul Foerster | 2020-03-04 13:52:49 | Re: pg_dump and public schema |
| Previous Message | stan | 2020-03-04 13:15:48 | Re: Calling a function from a rule? |