X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 70C3654E09 for ; Thu, 3 Mar 2005 12:17:34 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 45604-09 for ; Thu, 3 Mar 2005 12:17:30 +0000 (GMT) Received: from mail.logix-tt.com (wallaby.dingens.org [212.75.36.180]) by svr1.postgresql.org (Postfix) with ESMTP id 2E80152D45 for ; Thu, 3 Mar 2005 12:17:29 +0000 (GMT) Received: from kingfisher.intern.logi-track.com (pD95DCDF2.dip0.t-ipconnect.de [217.93.205.242]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by mail.logix-tt.com (Postfix) with ESMTP id C8C20A85D7; Thu, 3 Mar 2005 12:17:31 +0000 (UTC) Received: from [127.0.0.1] (localhost [127.0.0.1]) by kingfisher.intern.logi-track.com (Postfix) with ESMTP id E18B5AB0F9; Thu, 3 Mar 2005 13:17:25 +0100 (CET) Message-ID: <42270055.1000608@logix-tt.com> Date: Thu, 03 Mar 2005 13:17:25 +0100 From: Markus Schaber User-Agent: Mozilla Thunderbird 1.0 (X11/20050116) X-Accept-Language: de-DE, de, en-us, en MIME-Version: 1.0 To: lucas@presserv.org Cc: pgsql-sql@postgresql.org Subject: Re: Multiples schemas References: <20050302083033.2kb2nn2x30gkko08@www.presserv.org> In-Reply-To: <20050302083033.2kb2nn2x30gkko08@www.presserv.org> X-Enigmail-Version: 0.90.1.0 X-Enigmail-Supports: pgp-inline, pgp-mime Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.05 tagged_above=0 required=5 tests=FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200503/40 X-Sequence-Number: 20519 Hi, Lucas, lucas@presserv.org schrieb: > Is there a way to construct a multi schema in my data base? > Something like: > mysystem.finances.money.tables > mysystem.finances.money.functions > mysystem.finances.credits.tables > mysystem.finances.credits.functions > mysystem.amount.products...... > .... AFAIK, there is no way to have hierarchical schemas, but if you only need it for humans, you can name your schemas like finances_money_tables and finances_money_functions. > Or can I use another database like: > createdb DB1 > createdb DB2 > psql DB1 > select * from DB2.schema.table In contrib/, there's a dblink module that lets you select data from other databases, but I'm afraid it is rather limited in usage and performance. Markus -- Markus Schaber | Dipl. Informatiker | Software Development GIS Fight against software patents in EU! http://ffii.org/ http://nosoftwarepatents.org/