Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 42A4B6336C6 for ; Tue, 31 Mar 2009 09:35:07 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 67851-07 for ; Tue, 31 Mar 2009 09:35:05 -0300 (ADT) X-Greylist: delayed 00:31:35.063589 by SQLgrey-1.7.6 Received: from easy2.in-chemnitz.de (easy2.in-chemnitz.de [88.198.17.232]) by mail.postgresql.org (Postfix) with ESMTP id B2CD7633468 for ; Tue, 31 Mar 2009 09:35:05 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by easy2.in-chemnitz.de (Postfix) with ESMTP id 22FF747001F for ; Tue, 31 Mar 2009 14:03:28 +0200 (CEST) Received: from easy2.in-chemnitz.de ([127.0.0.1]) by localhost (easy.in-chemnitz.de [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 56iQNLcbBGUM for ; Tue, 31 Mar 2009 14:03:28 +0200 (CEST) Received: by easy2.in-chemnitz.de (Postfix, from userid 1013) id 1079B47001E; Tue, 31 Mar 2009 14:03:28 +0200 (CEST) Date: Tue, 31 Mar 2009 14:03:28 +0200 From: Tino Schwarze To: pgsql-admin@postgresql.org Subject: Re: Data type to store files Message-ID: <20090331120328.GC19973@easy2.in-chemnitz.de> References: <006d01c9b183$09470050$3000a8c0@atenea> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: User-Agent: Mutt/1.5.13 (2006-08-11) 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: 200903/261 X-Sequence-Number: 31761 On Tue, Mar 31, 2009 at 08:31:43AM -0300, Agustin Ignacio Genoves wrote: > I guess you should use Bytea Or go for large objects. > > Greetings: > > > > I need to use a PostgreSQL Data Base to store different kinds of files, eg: > > images, videos. So, I'm wondering what data type should I use. > > > > Tbanks in advance HTH, Tino. -- "What we nourish flourishes." - "Was wir nähren erblüht." www.lichtkreis-chemnitz.de www.craniosacralzentrum.de