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 8A05BDBCBD for ; Sat, 19 Nov 2005 23:04:11 -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 52589-09 for ; Sun, 20 Nov 2005 03:04:15 +0000 (GMT) X-Greylist: delayed 00:15:01.869257 by SQLgrey- Received: from S3.cableone.net (s3.cableone.net [24.116.0.229]) by svr1.postgresql.org (Postfix) with ESMTP id BBFDBDBC9F for ; Sat, 19 Nov 2005 23:04:08 -0400 (AST) Received: from mymail3direct.cableone.net (unverified [24.116.1.7]) by S3.cableone.net (CableOne SMTP Service S3) with ESMTP id 37634584 for ; Sat, 19 Nov 2005 20:03:04 -0700 Content-Disposition: inline Content-Transfer-Encoding: binary Mime-Version: 1.0 From: To: pgsql-sql@postgresql.org Subject: Create Public Schema Reply-To: rsosnowski@cableone.net Content-Type: text/html; X-Origin: 72.24.122.48 Date: Sat, 19 Nov 2005 20:03:04 -0700 Message-ID: <1132455784_77546@S3.cableone.net> X-IP-stats: Incoming Last 0, First 387, in=101593, out=0, spam=0 X-External-IP: 24.116.1.7 X-Abuse-Info: Send abuse complaints to abuse@cableone.net X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=2.009 required=5 tests=[HTML_10_20=0.945, HTML_MESSAGE=0.001, HTML_MIME_NO_HTML_TAG=0.512, MIME_HTML_ONLY=0.001, NO_REAL_NAME=0.55] X-Spam-Score: 2.009 X-Spam-Level: ** X-Archive-Number: 200511/161 X-Sequence-Number: 23412 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.

Thanks....Rob