Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id D017C650E81 for ; Mon, 30 Jun 2008 20:48:10 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 49842-01 for ; Mon, 30 Jun 2008 20:48:02 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from megazone.bigpanda.com (megazone.bigpanda.com [64.147.171.210]) by postgresql.org (Postfix) with ESMTP id 5664E650DBC for ; Mon, 30 Jun 2008 20:48:07 -0300 (ADT) Received: by megazone.bigpanda.com (Postfix, from userid 1001) id C252236025; Mon, 30 Jun 2008 16:48:05 -0700 (PDT) Received: from localhost (localhost [127.0.0.1]) by megazone.bigpanda.com (Postfix) with ESMTP id C026B36015; Mon, 30 Jun 2008 16:48:05 -0700 (PDT) Date: Mon, 30 Jun 2008 16:48:05 -0700 (PDT) From: Stephan Szabo To: kevin kempter Cc: pgsql-admin@postgresql.org Subject: Re: pg_tables query issue In-Reply-To: <9DF35265-815F-4F13-83C1-2461F57F2F72@kevinkempterllc.com> Message-ID: <20080630164625.I75058@megazone.bigpanda.com> References: <9DF35265-815F-4F13-83C1-2461F57F2F72@kevinkempterllc.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200806/263 X-Sequence-Number: 29601 > I've found that if I run this select (below) I get a table returned > named 'dma' een though I specified like 'dm_%' : Underscore is a special character for like matching any single character so I don't think that's wrong.