From: "codeWarrior" <gpatnude@hotmail.com>
Subject: Re: using pg_tables and tablename in queries
Date: Wed, 5 Oct 2005 08:24:11 -0700
Organization: Hub.Org Networking Services
Lines: 38
Message-ID: <di0r63$2qgl$1@news.hub.org>
References: <aa44f4a30510040930m510bbe8do4babd97b1b37c90d@mail.gmail.com>
	<9420.1128445291@sss.pgh.pa.us>
To: pgsql-sql@postgresql.org


"Tom Lane" <tgl@sss.pgh.pa.us> wrote in message 
news:9420.1128445291@sss.pgh.pa.us...
> solarsail <solarsail@gmail.com> writes:
>> I have a large number of tables with a common naming convention
>
>> mytable001, mytable002, mytable003 ... mytable00n
>
>> I would like to do a query across all of the tables, however I do not 
>> know
>> all of the tables before hand, and I do not want to ( cant ) manually
>> generate a query like
>
>> select * from mytable001, mytable002, mytable003
>
>> I have a query that returns the names of the tables I want to query:
>
>> select tablename from pg_tables where tablename like 'mytable%'
>
> This looks to me like a situation in which you should rethink your
> data design.  Those tables should all get merged into one big table,
> adding one extra column that reflects what you had been using to
> segregate the data into different tables.
>
> regards, tom lane

Sounds like a classic opportunity to use the postgreSQL inheritance model to 
me....


>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
>               http://archives.postgresql.org
>