Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 63DDCB5DBDF for ; Wed, 18 May 2011 17:56:23 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 58476-04 for ; Wed, 18 May 2011 20:56:16 +0000 (UTC) X-Greylist: delayed 00:09:50.758781 by SQLgrey-1.7.6 Received: from relaygateway02.edpnet.net (relaygateway02.edpnet.net [212.71.1.211]) by mail.postgresql.org (Postfix) with ESMTP id 240CBB5DBDE for ; Wed, 18 May 2011 17:56:15 -0300 (ADT) X-IronPort-Anti-Spam-Filtered: true X-IronPort-Anti-Spam-Result: AnkHAOEv1E1V6sUd/2dsb2JhbACEWZM2jgx4tXKQe4USgQcEjA6Seg X-IronPort-AV: E=Sophos;i="4.65,233,1304287200"; d="vcf'?scan'208";a="8861731" Received: from 85.234.197.29.wls.msr02str3.adsl.dyn.edpnet.net (HELO rivendell.lan) ([85.234.197.29]) by relaygateway02.edpnet.net with ESMTP; 18 May 2011 22:46:23 +0200 Message-ID: <4DD4301F.4010403@ulb.ac.be> Date: Wed, 18 May 2011 22:46:23 +0200 From: Julien Cigar User-Agent: Mozilla/5.0 (X11; U; FreeBSD i386; en-US; rv:1.9.2.17) Gecko/20110430 Thunderbird/3.1.10 MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: Re: column type for pdf file References: <4DD42A1C.30202@encs.concordia.ca> In-Reply-To: <4DD42A1C.30202@encs.concordia.ca> Content-Type: multipart/mixed; boundary="------------020404010208000808020207" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-5 required=5 tests=BAYES_00=-1.9 X-Spam-Level: X-Archive-Number: 201105/104 X-Sequence-Number: 35388 This is a multi-part message in MIME format. --------------020404010208000808020207 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Unless you've good reasons to do so it's best to store the file on the file system and the file name/path in the database ... On 05/18/2011 22:20, Emi Lu wrote: > Hello, > > To save pdf files into postgresql8.3, what is the best column type? > > bytea, blob, etc? > > Thank you, > Emi > --------------020404010208000808020207 Content-Type: text/x-vcard; charset=utf-8; name="jcigar.vcf" Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename="jcigar.vcf" begin:vcard fn:Julien Cigar n:Cigar;Julien org;quoted-printable:Universit=C3=A9 Libre de Bruxelles adr:;;;;;;Belgium email;internet:jcigar@ulb.ac.be tel;cell:+32 (0) 473 30 71 92 x-mozilla-html:FALSE url:http://www.biodiversity.be version:2.1 end:vcard --------------020404010208000808020207--