Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 63EBA9FB4F7 for ; Wed, 13 Jun 2007 06:09:28 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 43027-06 for ; Wed, 13 Jun 2007 06:09:23 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from developer.pgadmin.org (developer.pgadmin.org [63.246.23.140]) by postgresql.org (Postfix) with ESMTP id 1980B9FB224 for ; Wed, 13 Jun 2007 06:09:23 -0300 (ADT) Received: from snake.local ([62.232.55.118]) (authenticated bits=0) by developer.pgadmin.org (8.13.8/8.13.8) with ESMTP id l5D8r0FR014422 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Wed, 13 Jun 2007 08:53:01 GMT Message-ID: <466FB441.6000204@postgresql.org> Date: Wed, 13 Jun 2007 10:09:21 +0100 From: Dave Page User-Agent: Thunderbird 2.0.0.0 (Macintosh/20070326) MIME-Version: 1.0 To: Mihail Mihailov CC: pgsql-php@postgresql.org Subject: Re: php, postgresql and graphical images References: <20070613115155.uykzmxtvxueoo4w8@imp3.uta.fi> In-Reply-To: <20070613115155.uykzmxtvxueoo4w8@imp3.uta.fi> X-Enigmail-Version: 0.95.1 OpenPGP: url=http://www.pgadmin.org/pgp/davepage.pgp Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200706/5 X-Sequence-Number: 3807 Mihail Mihailov wrote: > Are there any other ways to export images from the database? Hi Mike, I store them in bytea columns, along with their mimetype, then use a script like: I should really rewrite that to use a parameterized query, but you get the idea :-) Regards, Dave