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 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
