Re: pg dump only indexes - Mailing list pgsql-admin

On Dec 16, 2013, at 5:42 PM, Campbell, Lance <lance@illinois.edu> wrote:

> PostgreSQL 9.2
> Is there a way to use pg_dump to dump just indexes on a database?

You can use --section=post-data and grep the INDEXES.

Or you can use pg_catalog.pg_indexes.indexdef for indexes.
http://www.postgresql.org/docs/9.2/static/view-pg-indexes.html

Thanks & Regards,
Vibhor Kumar
Blogs:http://vibhork.blogspot.com
http://vibhorkumar.wordpress.com