Re: Schema dump

On 1/2/20 5:47 AM, Tom Lane wrote:
> Sonam Sharma <sonams1209@gmail.com> writes:
>> I took a schema dump using : pg_dump -n schema dbname .
>> When I restored this , it doesn't contain the constraints and indexes. Can
>> someone please help how to take a dump including all
> 
> Hmph ... works for me.  Where by "works", I mean "the dump contains
> constraints and indexes belonging to tables in the specified schema,
> and not any others".  Maybe you could provide a little more detail?
> 
> (One thing I notice is that the dump doesn't contain a "CREATE
> SCHEMA schema" command, so you have to do that manually before
> you restore.  I guess this fits with the definition of the switch
> as selecting objects *in* the named schema, but it's still a
> possible gotcha.)

What version? As I see:

pg_dump -U postgres -d production -n utility -f utility_sch.sql

In utility_sch.sql:

CREATE SCHEMA utility;

I ask because the docs:

https://www.postgresql.org/docs/12/app-pgdump.html

"Dump only schemas matching pattern; this selects both the schema 
itself, and all its contained objects. "

support the idea that the schema definition is dumped.

> 
>             regards, tom lane
> 
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com