X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 617048BA0FE for ; Tue, 15 Feb 2005 15:51:56 +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 69136-01 for ; Tue, 15 Feb 2005 15:51:52 +0000 (GMT) Received: from 9.hellooperator.net (cpc3-cdif2-3-0-cust202.cdif.cable.ntl.com [81.103.32.202]) by svr1.postgresql.org (Postfix) with ESMTP id 9E9118BA0F9 for ; Tue, 15 Feb 2005 15:51:50 +0000 (GMT) Received: from [10.4.0.5] (helo=eris.tenfour) by 9.hellooperator.net with esmtp (Exim 4.43) id 1D14zM-0000sC-T3 for pgsql-admin@postgresql.org; Tue, 15 Feb 2005 15:51:50 +0000 Received: from rasputnik by eris.tenfour with local (Exim 4.44 (FreeBSD)) id 1D14zM-000EsM-MH for pgsql-admin@postgresql.org; Tue, 15 Feb 2005 15:51:48 +0000 Date: Tue, 15 Feb 2005 15:51:48 +0000 From: Dick Davies To: PostgreSQL Admin Subject: empty a database Message-ID: <20050215155148.GZ63378@eris.tenfour> Reply-To: Dick Davies Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.4.2.1i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.525 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO, RCVD_IN_NJABL_DUL, RCVD_IN_SORBS_DUL X-Spam-Level: * X-Archive-Number: 200502/122 X-Sequence-Number: 16290 Is there a neat way to clean out a database via SQL commands? i.e. get rid of tables, sequences, integers, etc. At present I'm using dropdb/createdb, but thats' far from ideal and I think it's causing postgres to do more mork than it needs to... -- 'My life, and by extension everyone else's, is meaningless.' -- Bender Rasputin :: Jack of All Trades - Master of Nuns