Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable
From: Teja Jakkidi <teja.jakkidi05@gmail.com>
Mime-Version: 1.0 (1.0)
Subject: Re: pg_dump and restore without indexes
Date: Tue, 4 Jun 2024 11:30:32 -0700
Message-Id: <D97C032D-6EF0-4E64-9E86-8D0D19B26BEB@gmail.com>
References: <8fbe6cf1-99b8-4af2-a147-acd90cd21907@ewie.name>
Cc: pgsql-admin <pgsql-admin@lists.postgresql.org>
In-Reply-To: <8fbe6cf1-99b8-4af2-a147-acd90cd21907@ewie.name>
To: Erik Wienhold <ewie@ewie.name>
Archived-At: 
 <https://www.postgresql.org/message-id/D97C032D-6EF0-4E64-9E86-8D0D19B26BEB%40gmail.com>
Precedence: bulk

Thank you for your inputs, Erik.

Regards,
J. Teja.

> On Jun 4, 2024, at 11:27=E2=80=AFAM, Erik Wienhold <ewie@ewie.name> wrote:=

>=20
> =EF=BB=BFOn 2024-06-04 19:58 +0200, Teja Jakkidi wrote:
>> Also, is there a way we can remap schema or table during restore like
>> how we have an option to remap in Oracle?
>=20
> Not in pg_dump or pg_restore.  Maybe some third-party tool, but I don't
> know.
>=20
> I had to do this in the past and just renamed the schemas after
> restoring into a new database.  Using a find-and-replace on the SQL dump
> might also work (maybe with a clever regexp) but it's not foolproof if
> the search matches false-positives in data segments or string literals.
>=20
> --
> Erik