Re: [ADMIN] pg_tables query issue

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 someth

Re: [ADMIN] pg_tables query issue

OK. Thanks for the info. On Jun 30, 2008, at 5:48 PM, Stephan Szabo wrote: I've found that if I run this select (below) I get a table returned named 'dma' een though I specified like 'dm_%' : Underscore is a special character for like matching any single character so I don't think that'

Re: [ADMIN] pg_tables query issue

> I've found that if I run this select (below) I get a table returned > named 'dma' een though I specified like 'dm_%' : Underscore is a special character for like matching any single character so I don't think that's wrong. -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To m

[ADMIN] pg_tables query issue

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 somethi