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.
> I executed pg_dump as postgres user, the server and pg_dump are version 9.3.5. I suspect it’s missing
> some permissions, but not able to figure out what permissions are missing. Below is the permission on
> test schema:
> 
> 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 |
> 

It works on my 9.3.6 database:

$ pg_dump -p 1235 -s -n laurenz test|grep 'CREATE SCHEMA'
CREATE SCHEMA laurenz;

You don't need any permissions to dump a schema, everybody can read the information.

Could you double check with a "grep" or so that there is indeed no CREATE SCHEMA
in your dump?

Yours,
Laurenz Albe