From: Tom Lane <tgl@sss.pgh.pa.us>
To: Sylvain Cuaz <sylvain@ilm-informatique.fr>
cc: pgsql-general@lists.postgresql.org
Subject: Re: Restoring only a subset of schemas
In-reply-to: <238e8c2a-b202-41b4-92e9-c0dbc4700c26@ilm-informatique.fr>
References: <7d869dac-5fe0-488c-a7a1-436b1d939057@ilm-informatique.fr> <4009720.1742225376@sss.pgh.pa.us> <238e8c2a-b202-41b4-92e9-c0dbc4700c26@ilm-informatique.fr>
Comments: In-reply-to Sylvain Cuaz <sylvain@ilm-informatique.fr>
	message dated "Wed, 19 Mar 2025 09:24:05 +0100"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <710892.1742400806.1@sss.pgh.pa.us>
Content-Transfer-Encoding: quoted-printable
Date: Wed, 19 Mar 2025 12:13:26 -0400
Message-ID: <710893.1742400806@sss.pgh.pa.us>
Archived-At: <https://www.postgresql.org/message-id/710893.1742400806%40sss.pgh.pa.us>
Precedence: bulk

Sylvain Cuaz <sylvain@ilm-informatique.fr> writes:
> Further, I don't see how it's an edge-case, at the core I just want to r=
estore some but not all the =

> schemas. This is possible for pg_dump, see my response to Adrian Klaver.

You have a very good point that it's annoying that pg_restore's
--schema switch doesn't act like pg_dump's --schema switch.
I could support changing that, but only if we also did something
about the fact that pg_restore's switch doesn't handle patterns.

The pattern aspect is kind of a mess, because pg_dump implements
that through a server-side regex, which is a facility pg_restore
doesn't have access to.  Maybe it'd be good enough to implement
the "*" and "?" wildcards and stop there, but I'm not sure.

			regards, tom lane