Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id B7BFC2E3197 for ; Wed, 2 Jan 2008 12:44:32 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 13418-02-6 for ; Wed, 2 Jan 2008 12:44:28 -0400 (AST) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 6425D2E3495 for ; Wed, 2 Jan 2008 12:44:28 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.1/8.14.1) with ESMTP id m02GiOSj016571; Wed, 2 Jan 2008 11:44:24 -0500 (EST) To: "=?ISO-8859-13?Q?Ignas_=D0altis?=" cc: pgsql-admin@postgresql.org Subject: Re: pg_dump and blobs In-reply-to: <3fa710c50801020753h46fb0473rfe5d7c270cf9f5d9@mail.gmail.com> References: <3fa710c50801020753h46fb0473rfe5d7c270cf9f5d9@mail.gmail.com> Comments: In-reply-to "=?ISO-8859-13?Q?Ignas_=D0altis?=" message dated "Wed, 02 Jan 2008 17:53:36 +0200" Date: Wed, 02 Jan 2008 11:44:24 -0500 Message-ID: <16570.1199292264@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200801/20 X-Sequence-Number: 27794 "=?ISO-8859-13?Q?Ignas_=D0altis?=" writes: > How can I make dump without blobs? Per the manual: -b --blobs Include large objects in the dump. This is the default behavior except when --schema, --table, or --schema-only is specified, so the -b switch is only useful to add large objects to selective dumps. regards, tom lane