Re: pg dump only indexes

From: Vibhor Kumar <vibhor(dot)aim(at)gmail(dot)com>
To: "Campbell, Lance" <lance(at)illinois(dot)edu>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: pg dump only indexes
Date: 2013-12-16 22:48:59
Message-ID: FB12A506-8A73-4A89-862B-5F0B27B14448@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


On Dec 16, 2013, at 5:42 PM, Campbell, Lance <lance(at)illinois(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message bricklen 2013-12-16 22:51:07 Re: pg dump only indexes
Previous Message Campbell, Lance 2013-12-16 22:42:34 pg dump only indexes