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
