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 39B868B9E2E for ; Sat, 19 Feb 2005 13:37:58 +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 49112-07 for ; Sat, 19 Feb 2005 13:37:46 +0000 (GMT) Received: from 21cn.com (send.forptr.21cn.com [202.105.45.49]) by svr1.postgresql.org (Postfix) with SMTP id 05E418BA55A for ; Sat, 19 Feb 2005 13:37:42 +0000 (GMT) Received: from bonjovi([127.0.0.1]) by 21cn.com(AIMC 2.9.5.6 P2) with SMTP id jm942174ade; Sat, 19 Feb 2005 21:39:18 +0800 Received: from bonjovi([222.68.3.36]) by 21cn.com(AIMC 2.9.5.4) with SMTP id AISP action; Sat, 19 Feb 2005 21:39:18 +0800 Date: Sat, 19 Feb 2005 21:37:21 +0800 From: "guly" Reply-To: gulyxxf@21cn.com To: "pgsql-admin" Subject: how to dump one table with large objects X-mailer: Foxmail 5.0 [cn] Mime-Version: 1.0 Content-Type: text/plain; charset="gb2312" Content-Transfer-Encoding: 7bit X-AIMC-AUTH: gulyxxf X-AIMC-MAILFROM: gulyxxf@21cn.com Message-ID: <7q949780786081.02392@send5.inner-21cn.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.383 tagged_above=0 required=5 tests=AWL, DNS_FROM_AHBL_RHSBL, DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST X-Spam-Level: * X-Archive-Number: 200502/174 X-Sequence-Number: 16342 I want to dump only one table with large-object. I typed "pg_dump -bv -Fc -Z9 -t table -d db > expdb &" on command line .But OS showed error "large-object output not supported for a single table" .Should I dump all db if there are some large objects in table? jovi