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