Re: pg_dump and restore without indexes

Thank you, Erik.
Will try this option.

Also, is there a way we can remap schema or table during restore like how we have an option to remap in Oracle?

Thank,
J. Teja.

> On Jun 4, 2024, at 10:56 AM, Erik Wienhold <ewie@ewie.name> wrote:
>
> On 2024-06-04 19:42 +0200, Teja Jakkidi wrote:
>> I am trying to look for an option that can be added in pg_dump command
>> to ignore all the indexes when creating the schema dump with data.  Is
>> there any such option that can be used in pg_dump? Or in pg_restore?
>
> You can get the table of contents with pg_restore --list and remove or
> comment out the INDEX entries in that file.  Then feed the TOC back into
> pg_restore with --use-list.  The implicit indexes for primary key and
> unique constraints will still be created, though.
>
> --
> Erik