Thanks for the help everyone. I got everything working. The query I was orignally looking for was something like this:
SELECT * from mytable WHERE pg_tables.tablename IN ( select tablename from pg_tables where tablename like 'mytable _%' ) It turns out that isn't what I really wanted. I now have a nice stored procedure, with a clean interface. Thanks for all the help! On 10/5/05, codeWarrior <[EMAIL PROTECTED]> wrote: > > "Tom Lane" <[EMAIL PROTECTED]> wrote in message > news:[EMAIL PROTECTED] > > solarsail <[EMAIL PROTECTED]> 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 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly