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@xxxxxxxxx> 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
