pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedpg_tables query issue
4+ messages / 3 participants
[nested] [flat]
* pg_tables query issue
@ 2008-06-30 23:42 kevin kempter <kevin@kevinkempterllc.com>
0 siblings, 2 replies; 4+ messages in thread
From: kevin kempter @ 2008-06-30 23:42 UTC (permalink / raw)
To: 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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: pg_tables query issue
@ 2008-06-30 23:48 Stephan Szabo <sszabo@megazone.bigpanda.com>
parent: kevin kempter <kevin@kevinkempterllc.com>
1 sibling, 1 reply; 4+ messages in thread
From: Stephan Szabo @ 2008-06-30 23:48 UTC (permalink / raw)
To: kevin kempter <kevin@kevinkempterllc.com>; +Cc: pgsql-admin
> 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.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: pg_tables query issue
@ 2008-07-01 00:26 kevin kempter <kevin@kevinkempterllc.com>
parent: Stephan Szabo <sszabo@megazone.bigpanda.com>
0 siblings, 0 replies; 4+ messages in thread
From: kevin kempter @ 2008-07-01 00:26 UTC (permalink / raw)
To: Stephan Szabo <sszabo@megazone.bigpanda.com>; +Cc: pgsql-admin
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's wrong.
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: pg_tables query issue
@ 2008-07-01 13:09 Lennin Caro <lennin.caro@yahoo.com>
parent: kevin kempter <kevin@kevinkempterllc.com>
1 sibling, 0 replies; 4+ messages in thread
From: Lennin Caro @ 2008-07-01 13:09 UTC (permalink / raw)
To: pgsql-admin@postgresql.org, kevin kempter <kevin@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\\_%')
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2008-07-01 13:09 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-06-30 23:42 pg_tables query issue kevin kempter <kevin@kevinkempterllc.com>
2008-06-30 23:48 ` Stephan Szabo <sszabo@megazone.bigpanda.com>
2008-07-01 00:26 ` kevin kempter <kevin@kevinkempterllc.com>
2008-07-01 13:09 ` Lennin Caro <lennin.caro@yahoo.com>
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