Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 90A739FB652 for ; Fri, 9 Mar 2007 09:06:03 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024) with ESMTP id 75224-01-6 for ; Fri, 9 Mar 2007 09:05:59 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from ciao.gmane.org (main.gmane.org [80.91.229.2]) by postgresql.org (Postfix) with ESMTP id 98BB39FBA9E for ; Fri, 9 Mar 2007 09:05:58 -0400 (AST) Received: from list by ciao.gmane.org with local (Exim 4.43) id 1HPen2-0006z9-4z for pgsql-admin@postgresql.org; Fri, 09 Mar 2007 14:05:44 +0100 Received: from pirus.securax.be ([213.16.46.130]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Fri, 09 Mar 2007 14:05:44 +0100 Received: from milen by pirus.securax.be with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Fri, 09 Mar 2007 14:05:44 +0100 X-Injected-Via-Gmane: http://gmane.org/ To: pgsql-admin@postgresql.org From: "Milen A. Radev" Subject: Re: Pg_dump and bytaA Date: Fri, 09 Mar 2007 15:05:20 +0200 Lines: 22 Message-ID: References: <53561.85.206.198.223.1173384127.squirrel@fmf.vtu.lt> <200703091005.24820.achill@matrix.gatewaynet.com> <57425.85.206.198.223.1173430811.squirrel@fmf.vtu.lt> <200703091150.09431.achill@matrix.gatewaynet.com> Mime-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit X-Complaints-To: usenet@sea.gmane.org X-Gmane-NNTP-Posting-Host: pirus.securax.be User-Agent: Thunderbird 2.0b2 (Windows/20070116) In-Reply-To: <200703091150.09431.achill@matrix.gatewaynet.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200703/34 X-Sequence-Number: 24858 Achilleas Mantzios wrote: > Στις Παρασκευή 09 Μάρτιος 2007 11:00, ο/η Lukas έγραψε: >> Hello, >> >> pg_dump can avoid bloob fields (it can dumb without blobs), but as I >> understand byteA is not bloob, so in this case what is blob? I did not >> found such type as blob.. >> > > Take a look at > http://www.postgresql.org/docs/7.4/interactive/largeobjects.html > > You might also consider writing a program for transforming your db/app > from bytea based to large object based, and simply exclude blobs > from your pg_dump's. How to exclude them from a custom dump? (That's for version 8.1/8.2) -- Milen A. Radev