Re: Using wildcard for table name ?

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>
Subject: Re: Using wildcard for table name ?
Date: 2013-07-29 06:38:39
Message-ID: CAKoxK+5M+5mj2ATN-YG1sPtav+zUcd23yMRSt3EGPqHYatrEUw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Luca Ferrari 2013-07-29 08:48:40 Re: Passing arguments to a function called by a trigger
Previous Message amulsul 2013-07-29 01:22:39 Re: Passing arguments to a function called by a trigger