X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id EA20AD6F49 for ; Sun, 20 Nov 2005 06:35:19 -0400 (AST) 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 40995-01 for ; Sun, 20 Nov 2005 10:35:21 +0000 (GMT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from ls405.htnet.hr (ls405.htnet.hr [195.29.150.97]) by svr1.postgresql.org (Postfix) with ESMTP id 246B5D6DC2 for ; Sun, 20 Nov 2005 06:35:16 -0400 (AST) Received: from ls401.t-com.hr (ls401.t-com.hr [195.29.150.236]) by ls405.htnet.hr (0.0.0/8.12.10) with ESMTP id jAKAZFWj028547; Sun, 20 Nov 2005 11:35:15 +0100 Received: from ls401.t-com.hr (localhost.localdomain [127.0.0.1]) by ls401.t-com.hr (Qmlai) with ESMTP id 6763D70003; Sun, 20 Nov 2005 11:35:15 +0100 (CET) X-Envelope-Sender: mario.splivalo@mobart.hr X-Envelope-Sender: mario.splivalo@mobart.hr Received: from 83-131-13-220.adsl.net.t-com.hr (83-131-13-220.adsl.net.t-com.hr [83.131.13.220]) by ls401.t-com.hr (Qmlai) with ESMTP id 18A42A8002; Sun, 20 Nov 2005 11:35:14 +0100 (CET) Subject: Re: Create Public Schema From: Mario Splivalo Reply-To: mario.splivalo@mobart.hr To: rsosnowski@cableone.net Cc: pgsql-sql@postgresql.org In-Reply-To: <1132455784_77546@S3.cableone.net> References: <1132455784_77546@S3.cableone.net> Content-Type: text/plain Organization: Mob-Art Date: Sun, 20 Nov 2005 11:35:07 +0100 Message-Id: <1132482908.8298.0.camel@localhost.localdomain> Mime-Version: 1.0 X-Mailer: Evolution 2.4.1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[none] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200511/164 X-Sequence-Number: 23415 On Sat, 2005-11-19 at 20:03 -0700, rsosnowski@cableone.net wrote: > Hello all, > > I'm trying to create a schema that contains the default tables, > functions, etc. of the public schema. Using pgAdmin, when I create a > schema, it is blank - has no associated aggregates, tables, etc. How > would I create additional schems within a database that mirror the > public schema. > I guess your best bet would be to manually create all the scripts for your database/schema objects. Use pg_dump to create a 'database schema snapshot', and then use pg_restore -L to create scripts for objects you desire. Mike