Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 1B1DF650F0B for ; Tue, 1 Jul 2008 10:17:25 -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 18964-05-6 for ; Tue, 1 Jul 2008 10:17:10 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from n5b.bullet.mail.ac4.yahoo.com (n5b.bullet.mail.ac4.yahoo.com [76.13.13.75]) by postgresql.org (Postfix) with SMTP id CAEAB650F0F for ; Tue, 1 Jul 2008 10:09:32 -0300 (ADT) Received: from [76.13.13.26] by n5.bullet.mail.ac4.yahoo.com with NNFMP; 01 Jul 2008 05:03:05 -0000 Received: from [76.13.10.183] by t3.bullet.mail.ac4.yahoo.com with NNFMP; 01 Jul 2008 13:09:29 -0000 Received: from [127.0.0.1] by omp124.mail.ac4.yahoo.com with NNFMP; 01 Jul 2008 13:09:29 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 759626.35118.bm@omp124.mail.ac4.yahoo.com Received: (qmail 41919 invoked by uid 60001); 1 Jul 2008 13:09:29 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Received:X-Mailer:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type:Message-ID; b=onmqhlIEplFW16d2kLwCGtKFaXrpsfHa+ZGU8TGqIB6uLUg/2g/R9T6SVw8NrPo0jVdyJSJH38tp0OG4dDHWP6nE5O8nEpMLkm8aNs/eQszNLTzvspc/7ZrMKoDtP85Q9raEevVd3e5Ijiw5o3LHgp2MW1c8kdchv8fyAhg9bBM=; Received: from [209.88.228.11] by web59516.mail.ac4.yahoo.com via HTTP; Tue, 01 Jul 2008 06:09:29 PDT X-Mailer: YahooMailWebService/0.7.199 Date: Tue, 1 Jul 2008 06:09:29 -0700 (PDT) From: Lennin Caro Subject: Re: pg_tables query issue To: pgsql-admin@postgresql.org, kevin kempter In-Reply-To: <9DF35265-815F-4F13-83C1-2461F57F2F72@kevinkempterllc.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Message-ID: <482405.41252.qm@web59516.mail.ac4.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=2.137 tagged_above=0 required=5 tests=AWL=-0.051, RCVD_IN_BL_SPAMCOP_NET=2.188 X-Spam-Level: ** X-Archive-Number: 200807/14 X-Sequence-Number: 29624 Hi List; I've found that if I run this select (below) I get a table returned named 'dma' een though I specified like 'dm_%' : select tablename from pg_tables where tablename like 'dm_%'; tablename ------------------------------ dm_service_provider_dim dma Am I missing something or is this a bug ? Thanks in advance.. /Kevin >> the '_' character is a especial character like the '%'.... Try use this >>select * from table where name ilike('dm\\_%')