Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 0CFB564FC03 for ; Fri, 26 Sep 2008 00:57:52 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 04438-04 for ; Fri, 26 Sep 2008 00:57:49 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from rv-out-0506.google.com (rv-out-0506.google.com [209.85.198.239]) by postgresql.org (Postfix) with ESMTP id E763564FC02 for ; Fri, 26 Sep 2008 00:57:48 -0300 (ADT) Received: by rv-out-0506.google.com with SMTP id b25so675256rvf.43 for ; Thu, 25 Sep 2008 20:57:47 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from :user-agent:mime-version:to:cc:subject:references:in-reply-to :content-type:content-transfer-encoding; bh=93f4I6osVysJFHt8Yg4pWIw2oKqbWoHPjnG+6RhITpc=; b=sKn0fTSWYF4DBdO/Ksc0STsSTyRz+8oEGdQejYk6Ph5gX8o1Z83FjfqoJK5vE4GKGW 7ANo2nN4cpinMs+Kc48ljs3PUo8tDy0r5XiD5l6IcByxOFa13koLhC3XJGn+g/ushW+P DRlEPKc7sYkSW1Kc0lpvlcImV52UXmkVlF5JM= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:user-agent:mime-version:to:cc:subject :references:in-reply-to:content-type:content-transfer-encoding; b=JVTiAsWohz/WidOOBcHmytyeADiTF6Ynpjkgi7XXs0lHm8NMDg4JaMncQJjO1F8Paf 2XVEhWath5XSaReYNz+TRCfQ0Hk0+2WcB5EaR0+I3x2wD6I+3ZZEQ9SFeUOC+YsY98Nr gjdzND5AcsKLdlwIM9rNBnFDUfIOkX2gkIdd4= Received: by 10.140.132.8 with SMTP id f8mr348842rvd.206.1222401467392; Thu, 25 Sep 2008 20:57:47 -0700 (PDT) Received: from ?192.168.0.70? ( [203.206.128.174]) by mx.google.com with ESMTPS id f21sm2134063rvb.5.2008.09.25.20.57.45 (version=TLSv1/SSLv3 cipher=RC4-MD5); Thu, 25 Sep 2008 20:57:46 -0700 (PDT) Message-ID: <48DC5DB6.2070706@gmail.com> Date: Fri, 26 Sep 2008 13:57:42 +1000 From: Chris User-Agent: Thunderbird 2.0.0.16 (X11/20080724) MIME-Version: 1.0 To: Rico Secada CC: pgsql-php@postgresql.org Subject: Re: Can't get PHP PDO LOB working with PostgreSQL (WRONG CODE) References: <20080925213217.f2d80566.coolzone@it.dk> In-Reply-To: <20080925213217.f2d80566.coolzone@it.dk> Content-Type: text/plain; charset=US-ASCII; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200809/10 X-Sequence-Number: 3896 > I don't know if the above is correct or if PostgreSQL has received the > binary data correctly, maybe someone can confirm this for me please? If it has an id, I suspect postgres got it just fine. > $stmt = $pdo->prepare("SELECT blob_type, attachment FROM attachments > WHERE id = :id LIMIT 1"); > $stmt->bindParam(':id', $_GET['id'], PDO::PARAM_STR); See examples here: http://au.php.net/manual/en/function.pdo-pgsqllobopen.php about how to get it back. -- Postgresql & php tutorials http://www.designmagick.com/