Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VsgyI-0004yN-HZ for pgsql-admin@arkaria.postgresql.org; Mon, 16 Dec 2013 22:49:06 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1VsgyH-0003w1-OG for pgsql-admin@arkaria.postgresql.org; Mon, 16 Dec 2013 22:49:05 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VsgyG-0003vv-RQ for pgsql-admin@postgresql.org; Mon, 16 Dec 2013 22:49:05 +0000 Received: from mail-qe0-x22b.google.com ([2607:f8b0:400d:c02::22b]) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VsgyD-0003K6-Kb for pgsql-admin@postgresql.org; Mon, 16 Dec 2013 22:49:03 +0000 Received: by mail-qe0-f43.google.com with SMTP id 2so4476309qeb.2 for ; Mon, 16 Dec 2013 14:49:01 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=content-type:mime-version:subject:from:in-reply-to:date:cc :content-transfer-encoding:message-id:references:to; bh=rkjyjkxOzeyXpsmmB+Lz73pitHTUos+QzXWTU/rzNCk=; b=CjMSD4es9+CNb2Vwe8bg/O/993zD6b8syMuMiqb8uVnz5ADIYkSjC1RbLAuJ4Jr3A8 /tMsphCvLNNx/tvqJtKsQQmz1Zs0hzMMS9rNF+Wd+pbnIpUMhPvdY0Pz3m15MADc+p++ YnXrxaha6NmJRAgfo9jI/ZhCwoAkLpT9SOAX5Rp4eK0UwB6Lr+fFXcJyhN/Ai1KhgC7r cHI6HXB6MkopC4zzzAVgqtCIWZ8yXMGNBfcQteDS9SBnBmg3GJZZsackbDSylFnigRjz k+PINZh5t/JHWfoY5aY0Gw6n4LTi0LngeED/C0IMnqn6k2/fMevO/52hVHT0CZ9GpXdJ kDaw== X-Received: by 10.224.11.7 with SMTP id r7mr36845081qar.91.1387234141107; Mon, 16 Dec 2013 14:49:01 -0800 (PST) Received: from [172.24.38.110] (70-91-216-177-BusName-NewEngland.hfc.comcastbusiness.net. [70.91.216.177]) by mx.google.com with ESMTPSA id o10sm49927985qaa.6.2013.12.16.14.49.00 for (version=TLSv1 cipher=ECDHE-RSA-RC4-SHA bits=128/128); Mon, 16 Dec 2013 14:49:00 -0800 (PST) Content-Type: text/plain; charset=us-ascii Mime-Version: 1.0 (Mac OS X Mail 7.0 \(1822\)) Subject: Re: pg dump only indexes From: Vibhor Kumar In-Reply-To: Date: Mon, 16 Dec 2013 17:48:59 -0500 Cc: "pgsql-admin@postgresql.org" Content-Transfer-Encoding: 7bit Message-Id: References: To: "Campbell, Lance" X-Mailer: Apple Mail (2.1822) X-Pg-Spam-Score: -0.6 (/) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org On Dec 16, 2013, at 5:42 PM, Campbell, Lance 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 -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin