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 33DB5D732F for ; Sun, 20 Nov 2005 04:46:27 -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 23124-04 for ; Sun, 20 Nov 2005 08:46:26 +0000 (GMT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from 137086.vserver.de (unknown [62.75.137.86]) by svr1.postgresql.org (Postfix) with ESMTP id 18EADD72C3 for ; Sun, 20 Nov 2005 04:46:22 -0400 (AST) Received: from a-kretschmer.de (p54B39330.dip0.t-ipconnect.de [84.179.147.48]) (authenticated bits=0) by 137086.vserver.de (8.12.8/8.12.8) with ESMTP id jAK8ivbM031426 for ; Sun, 20 Nov 2005 09:44:59 +0100 Received: from kretschmer by a-kretschmer.de with local (Exim 3.36 #1) id 1EdktH-0000S2-00 for pgsql-sql@postgresql.org; Sun, 20 Nov 2005 09:49:39 +0100 Date: Sun, 20 Nov 2005 09:49:39 +0100 From: Andreas Kretschmer To: pgsql-sql@postgresql.org Subject: Re: Create Public Schema Message-ID: <20051120084939.GA1692@kaufbach.delug.de> References: <1132455784_77546@S3.cableone.net> Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <1132455784_77546@S3.cableone.net> X-OS: Debian/GNU Linux - weil ich es mir Wert bin! X-GPG-Fingerprint: EE16 3C01 7B9C 10F7 2C8B 3B86 4DB3 D9EE 7F45 84DA X-Message-Flag: "Windows" is not the answer. "Windows" is the question and the answer is "no"! X-Lugdd: Gerd Kube X-Info: My name is root. Just root. And I am licensed to kill -9 User-Agent: mutt-ng 1.5.9i (Linux) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[AWL=0.000] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200511/162 X-Sequence-Number: 23413 rsosnowski@cableone.net schrieb: > 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 1. make a dump from the public-schema 2. edit the dump and change 'public' to 'foobar' (the new schema-name) 3. restore the schema from dump Now you have a exactly copy from 'public' with name 'foobar'. HTH, Andreas -- Really, I'm not out to destroy Microsoft. That will just be a completely unintentional side effect. (Linus Torvalds) Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°