From: Lennin Caro <lennin.caro@yahoo.com>
To: pgsql-admin@postgresql.org, kevin kempter <kevin@kevinkempterllc.com>
Subject: Re: pg_tables query issue
Date: Tue, 1 Jul 2008 06:09:29 -0700 (PDT)
Message-ID: <482405.41252.qm@web59516.mail.ac4.yahoo.com> (raw)
In-Reply-To: <9DF35265-815F-4F13-83C1-2461F57F2F72@kevinkempterllc.com>
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\\_%')
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: lennin.caro@yahoo.com, kevin@kevinkempterllc.com
Subject: Re: pg_tables query issue
In-Reply-To: <482405.41252.qm@web59516.mail.ac4.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox