OK Luca you are right, a view is a good solution. Thank you
From: Luca Ferrari <fluca1978@infinito.it> To: Francisco Leovey <fleovey@yahoo.com> Cc: "pgsql-novice@postgresql.org" <pgsql-novice@postgresql.org> Sent: Monday, July 29, 2013 3:38 AM Subject: Re: [NOVICE] Using wildcard for table name ?
On Sat, Jul 27, 2013 at 12:26 AM, Francisco Leovey <fleovey@yahoo.com> wrote: > My question was solved by writing a Perl program that gets the table names > as a list from the database structure and then simply searching each table. > Years ago I worked with Informix and there was a syntax for using a variable
Will I believe partitioning is a better idea, why don't you provide a view that unions all the table you are interested in? So far it will be a consisnte SQL interface and you will not need any external application.