From: | Francisco Leovey <fleovey(at)yahoo(dot)com> |
---|---|
To: | Luca Ferrari <fluca1978(at)infinito(dot)it> |
Cc: | "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: Using wildcard for table name ? |
Date: | 2013-07-29 11:43:55 |
Message-ID: | 1375098235.34701.YahooMailNeo@web164906.mail.bf1.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
OK Luca you are right, a view is a good solution. Thank you
________________________________
From: Luca Ferrari <fluca1978(at)infinito(dot)it>
To: Francisco Leovey <fleovey(at)yahoo(dot)com>
Cc: "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)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(at)yahoo(dot)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.
Luca
From | Date | Subject | |
---|---|---|---|
Next Message | Daniel Gomez Blanco | 2013-07-29 13:06:07 | Re: User with "almost" superuser privileges |
Previous Message | James David Smith | 2013-07-29 10:41:50 | Re: Fwd: Tricky join and update with same table |