On 1/2/20 5:47 AM, Tom Lane wrote:
Sonam Sharma <sonams1209@xxxxxxxxx> 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@xxxxxxxxxxx
