Re: pg_dump not dumping some schemas

Yun Guo wrote:
>>> I use this command to dump schema:
>>> pg_dump -s -n test polling_etl > file.sql
>>>
>>> However, the file.sql file includes creation of all the objects in
>>> schema test, but not the creation of test schema itself.

>>> polling_etl=# \dn+ test
>>> List of schemas
>>> Name | Owner | Access privileges | Description
>>> ------+-------+-------------------+-------------
>>> test | test | test=UC/test +|
>>> | | pb_writer=UC/test+|
>>> | | =U/test +|
>>> | | postgres=U*C/test |

> I tried again. It¹s still not dumping CREATE SCHEMA. And weirdly it would
> work for some other schemas in the same database.
>
> -bash-4.1$ pg_dump -s -n test polling_etl | grep 'CREATE SCHEMA'
> -bash-4.1$ pg_dump -s -n test2 polling_etl | grep 'CREATE SCHEMA'
> CREATE SCHEMA test2;

That is disturbing.

Does the schema show up in a custom format dump?

pg_dump -s -n test -Fc polling_etl | pg_restore -l

Yours,
Laurenz Albe