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
