Received: from mail.postgresql.org (webmail.postgresql.org [216.126.85.28]) by mail.postgresql.org (8.11.1/8.11.1) with SMTP id f0RH3vq64243 for ; Sat, 27 Jan 2001 12:03:57 -0500 (EST) (envelope-from pgsql-sql-owner@postgresql.org) Received: from ural2.hszk.bme.hu (ural2.hszk.bme.hu [152.66.130.2]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f0R27iq81743 for ; Fri, 26 Jan 2001 21:07:44 -0500 (EST) (envelope-from kb136@hszk.bme.hu) Received: (from kb136@localhost) by ural2.hszk.bme.hu (8.9.3/8.9.3) id DAA19890; Sat, 27 Jan 2001 03:07:41 +0100 (MET) Date: Sat, 27 Jan 2001 03:07:41 +0100 (MET) From: Kovacs Baldvin X-Sender: kb136@ural2 To: pgsql-sql@postgresql.org Subject: Architectural question Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Archive-Number: 200101/415 X-Sequence-Number: 1091 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 ::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