Received: from crystal.sonosite.com (test.sonosite.com [199.108.95.8]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fAUJ1rm01233 for ; Fri, 30 Nov 2001 14:01:53 -0500 (EST) (envelope-from fushan.leong@SonoSite.com) Received: from milton.sonosite.com (unknown [172.20.53.53]) by crystal.sonosite.com (Postfix) with ESMTP id 4684217D5 for ; Fri, 30 Nov 2001 12:50:58 -0600 (CST) Received: by milton.sonosite.com with Internet Mail Service (5.5.2653.19) id ; Fri, 30 Nov 2001 10:59:25 -0800 Message-ID: <2DFBC8374F5A0F4E954C07C158844F323886EC@milton.sonosite.com> From: "Leong, Fushan" To: pgsql-admin@postgresql.org Subject: rename database Date: Fri, 30 Nov 2001 10:59:20 -0800 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2653.19) Content-Type: text/plain; charset="iso-8859-1" X-Archive-Number: 200111/197 X-Sequence-Number: 2722 Hi : I am working on the procedure to restore a database from dump file ( pg_dump ). I am thinking to create a new database, then restore the dump file, drop the old database and rename the old database to new database. Do postgres has command to rename the database?