Postgres Pro
Downloads
Home   >   mailing lists

Re: Using wildcard for table name ? - Mailing list pgsql-novice

From Luca Ferrari
Subject Re: Using wildcard for table name ?
Date
Msg-id CAKoxK+5M+5mj2ATN-YG1sPtav+zUcd23yMRSt3EGPqHYatrEUw@mail.gmail.com
Whole thread Raw
In response to Re: Using wildcard for table name ?  (Francisco Leovey <fleovey@yahoo.com>)
Responses Re: Using wildcard for table name ?  (Francisco Leovey <fleovey@yahoo.com>)
List pgsql-novice
Tree view 
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.

Luca

pgsql-novice by date:

Previous
From: amulsul
Date:
Subject: Re: Passing arguments to a function called by a trigger
Next
From: Luca Ferrari
Date:
Subject: Re: Passing arguments to a function called by a trigger