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 2836C55E4F for ; Wed, 2 Mar 2005 11:30:39 +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 24555-08 for ; Wed, 2 Mar 2005 11:30:36 +0000 (GMT) Received: from iracema.dnscenter.com.br (iracema.dnscenter.com.br [67.15.80.70]) by svr1.postgresql.org (Postfix) with ESMTP id 6F67855675 for ; Wed, 2 Mar 2005 11:30:35 +0000 (GMT) Received: from cpanel by iracema.dnscenter.com.br with local (Exim 4.44) id 1D6S3l-0000An-CQ for pgsql-sql@postgresql.org; Wed, 02 Mar 2005 08:30:33 -0300 Received: from 200.158.187.18 ([200.158.187.18]) by www.presserv.org (Horde) with HTTP for ; Wed, 2 Mar 2005 08:30:33 -0300 Message-ID: <20050302083033.2kb2nn2x30gkko08@www.presserv.org> Date: Wed, 2 Mar 2005 08:30:33 -0300 From: lucas@presserv.org To: pgsql-sql@postgresql.org Subject: Multiples schemas MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Disposition: inline Content-Transfer-Encoding: 7bit User-Agent: Internet Messaging Program (IMP) H3 (4.0) X-AntiAbuse: This header was added to track abuse, please include it with any abuse report X-AntiAbuse: Primary Hostname - iracema.dnscenter.com.br X-AntiAbuse: Original Domain - postgresql.org X-AntiAbuse: Originator/Caller UID/GID - [32001 502] / [47 12] X-AntiAbuse: Sender Address Domain - presserv.org X-Source: X-Source-Args: X-Source-Dir: X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.691 tagged_above=0 required=5 tests=AWL, NO_REAL_NAME X-Spam-Level: X-Archive-Number: 200503/17 X-Sequence-Number: 20496 Hi, 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...... .... Or can I use another database like: createdb DB1 createdb DB2 psql DB1 select * from DB2.schema.table Or i need to construct the tables in the same database and the same schema like: mysystemdb.amount.products mysystemdb.amount.vendors mysystemdb.amount.clients mysystemdb.finances.money .... Could I create a multi schema into another schema ??? or is there only one level for schema sctructs? Thanks for all