Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_dump / pgrestore question - cannot restore a single schema - Mailing list pgsql-admin

From David G. Johnston
Subject Re: pg_dump / pgrestore question - cannot restore a single schema
Date
Msg-id CAKFQuwYx6OWRA2WF3RkHgB13RZTSrRU44LiGYcwb7+O-LWuUTQ@mail.gmail.com
Whole thread Raw
In response to pg_dump / pgrestore question - cannot restore a single schema  ("S.Bob" <sbob@quadratum-braccas.com>)
Responses Re: pg_dump / pgrestore question - cannot restore a single schema  (Holger Jakobs <holger@jakobs.com>)
List pgsql-admin
Tree view
On Mon, Mar 23, 2020 at 4:47 PM S.Bob <sbob@quadratum-braccas.com> wrote:

However if I try to restore only one of the schemas it does not work, seems like it does not create the schema first:

Since you have to know the schema name anyway in order to restore that schema only just go ahead an create the schema before performing the restore.  It seems that since a schema is not "in itself" it doesn't get restored.  Doesn't seem like a problem.

David J.

pgsql-admin by date:

Previous
From: "S.Bob"
Date:
Subject: pg_dump / pgrestore question - cannot restore a single schema
Next
From: Holger Jakobs
Date:
Subject: Re: pg_dump / pgrestore question - cannot restore a single schema