Re: pg_tables query issue - Mailing list 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\\_%')