Skip site navigation (1) Skip section navigation (2)

pg_tables query issue

From: kevin kempter <kevin(at)kevinkempterllc(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: pg_tables query issue
Date: 2008-06-30 23:42:52
Message-ID: 9DF35265-815F-4F13-83C1-2461F57F2F72@kevinkempterllc.com (view raw or flat)
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






Responses

pgsql-admin by date

Next:From: Alvaro HerreraDate: 2008-06-30 23:45:36
Subject: Re: Configuring Shared Buffers
Previous:From: Rafael DomicianoDate: 2008-06-30 23:41:38
Subject: Re: Configuring Shared Buffers

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group