Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 0A0369FB208 for ; Tue, 16 Jan 2007 12:30:50 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024) with ESMTP id 00199-04 for ; Tue, 16 Jan 2007 12:30:37 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from tomts20-srv.bellnexxia.net (tomts20.bellnexxia.net [209.226.175.74]) by postgresql.org (Postfix) with ESMTP id 44AF09FB1D9 for ; Tue, 16 Jan 2007 12:30:37 -0400 (AST) Received: from acer.sympatico.ca ([65.95.130.209]) by tomts20-srv.bellnexxia.net (InterMail vM.5.01.06.13 201-253-122-130-113-20050324) with ESMTP id <20070116163036.GIOG24907.tomts20-srv.bellnexxia.net@acer.sympatico.ca> for ; Tue, 16 Jan 2007 11:30:36 -0500 Message-Id: <5.2.1.1.0.20070116112920.045a00b0@pop6.sympatico.ca> X-Sender: b1wudu74@pop6.sympatico.ca X-Mailer: QUALCOMM Windows Eudora Version 5.2.1 Date: Tue, 16 Jan 2007 11:30:31 -0500 To: pgsql-sql@postgresql.org From: Frank Bax Subject: Re: Droping indexes In-Reply-To: <5.2.1.1.0.20070116112458.009fb4d0@pop6.sympatico.ca> References: <40081.83800.qm@web30012.mail.mud.yahoo.com> Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii"; format=flowed X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200701/61 X-Sequence-Number: 27213 At 11:27 AM 1/16/07, Frank Bax wrote: >At 10:42 AM 1/16/07, Mario Behring wrote: >>Thank you for your advise..............I was thinking about doing exactly >>that, I wasn't sure on how to do it though, meaning, considering the info >>below, how should I use the CREATE INDEX command to create these indexes?? > > >This might provide a clue: > >pg_dump -t events | grep ^CREATE Sorry, perhaps this would be better pg_dump -s -t events | grep ^CREATE