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 C570BDB706 for ; Sun, 13 Nov 2005 22:34:05 -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 58297-04 for ; Mon, 14 Nov 2005 02:34:01 +0000 (GMT) X-Greylist: delayed 00:30:01.967926 by SQLgrey- Received: from challengelogistics.com.au (unknown [203.48.241.83]) by svr1.postgresql.org (Postfix) with ESMTP id 46E85DB715 for ; Sun, 13 Nov 2005 22:34:02 -0400 (AST) Received: from isis.challengelogistics.com.au ([192.168.160.31]) by sameagle with InterScan Messaging Security Suite; Mon, 14 Nov 2005 13:04:07 +1100 Received: from sandy01.challengelogistics.com.au ([192.168.160.3]) by isis.challengelogistics.com.au with Microsoft SMTPSVC(6.0.3790.1830); Mon, 14 Nov 2005 13:06:11 +1100 From: "Bath, David" Reply-To: dave.bath@unix.net To: pgsql-sql@postgresql.org Subject: selective dump pg_dump: only specific non-tables? with schema name? Date: Mon, 14 Nov 2005 13:08:06 +1100 User-Agent: KMail/1.8 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200511141308.07582.dave.bath@unix.net> X-OriginalArrivalTime: 14 Nov 2005 02:06:11.0734 (UTC) FILETIME=[FC302B60:01C5E8BF] X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.041 required=5 tests=[AWL=0.041] X-Spam-Score: 0.041 X-Spam-Level: X-Archive-Number: 200511/114 X-Sequence-Number: 23365 Hi folks, Three questions about pg_dump (that might be a feature request). Let me know if pg_dump is not the best tool for this sort of thing. 1. Can I pg_dump only non-table information from the command line e.g. single function, all functions, trigger definitions? 2. Can I pg_dump schema objects that include the schema prefix "inline" e.g. CREATE FUNCTION "fred"."func1" 3. Can I pg_dump "CREATE OR REPLACE" rather than straight "CREATE", especially for functions? -- David T. Bath dave.bath@unix.net