Architectural question

From: Kovacs Baldvin <kb136(at)hszk(dot)bme(dot)hu>
To: pgsql-sql(at)postgresql(dot)org
Subject: Architectural question
Date: 2001-01-27 02:07:41
Message-ID: Pine.GSO.4.21.0101270257110.15179-100000@ural2
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hello everybody.

I would like to create a database. It's a structure of about 20
items (tables, views, etc.)

Then I would like to make it a template, because I need 7 copies
of this structure, possibly a growing number.

The only problem is that there are four tables in it, which are
general, so it would be the finest to make them common. For
example in a database "commondb".

But I don't know if I could somehow create a construction like this:
SELECT * from sometable
WHERE somecolumn IN (SELECT * FROM <the-common-db>::atable)

Since now I used Delphi, and I could reference databases as
directories in my file system, so it wasn't a problem.

Any ideas to solve this?

Thanks in advance,
Baldvin

Browse pgsql-sql by date

  From Date Subject
Next Message Rodger Donaldson 2001-01-27 05:39:56 Re: Wild Cards
Previous Message Stephan Szabo 2001-01-27 01:48:07 Re: SQL Help