Re: pg_tables query issue

From: Lennin Caro <lennin(dot)caro(at)yahoo(dot)com>
To: pgsql-admin(at)postgresql(dot)org, kevin kempter <kevin(at)kevinkempterllc(dot)com>
Subject: Re: pg_tables query issue
Date: 2008-07-01 13:09:29
Message-ID: 482405.41252.qm@web59516.mail.ac4.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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\\_%')

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message JGuillaume (ioguix) de Rorthais 2008-07-01 15:32:49 Re: PostgreSQL web administration
Previous Message M. Sederqvist 2008-07-01 12:38:52 PostgreSQL web administration