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\\_%') -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin