Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1Tsh7S-0001z3-71 for pgsql-sql@arkaria.postgresql.org; Tue, 08 Jan 2013 21:54:02 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1Tsh7R-0005Ix-Bt for pgsql-sql@arkaria.postgresql.org; Tue, 08 Jan 2013 21:54:01 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1Tsh7Q-0005Is-OK for pgsql-sql@postgresql.org; Tue, 08 Jan 2013 21:54:00 +0000 Received: from oldperseverance.encs.concordia.ca ([132.205.96.94]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1Tsh7N-0005lC-NB for pgsql-sql@postgresql.org; Tue, 08 Jan 2013 21:54:00 +0000 Received: from cacao.encs.concordia.ca (emilu@cacao.encs.concordia.ca [132.205.47.225]) by oldperseverance.encs.concordia.ca (envelope-from emilu@encs.concordia.ca) (8.13.7/8.13.7) with ESMTP id r08LruPr011047 for ; Tue, 8 Jan 2013 16:53:56 -0500 Message-ID: <50EC9574.9060500@encs.concordia.ca> Date: Tue, 08 Jan 2013 16:53:56 -0500 From: Emi Lu Reply-To: emilu@encs.concordia.ca User-Agent: Mozilla/5.0 (X11; Linux i686; rv:17.0) Gecko/17.0 Thunderbird/17.0 MIME-Version: 1.0 To: PostgreSQL SQL List Subject: How to generate drop cascade with pg_dump Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Scanned-By: MIMEDefang 2.58 on oldperseverance.encs.concordia.ca at 2013/01/08 16:53:56 EST X-Pg-Spam-Score: -4.2 (----) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-sql Precedence: bulk Sender: pgsql-sql-owner@postgresql.org Hello, May I know how to generate drop table cascade when pg_dump a schema please? E.g., pg_dump -h db_server -E UTF8 -n schema_name -U schema_owner --clean -d db_name >! ~/a.dmp In a.dmp, I'd like to get: drop table t1 cascade; drop table t2 cascade; ... ... Only dropping constraints within a schema is not good enough since there are dependencies on other schema. Thanks a lot! Emi -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql