From fesanch@ciego.cult.cu Tue Mar 31 03:59:47 2009 Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id D5F00633CB8 for ; Tue, 31 Mar 2009 00:59:47 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 34453-04 for ; Tue, 31 Mar 2009 00:59:41 -0300 (ADT) Received: from mx1.hub.org (mx1.hub.org [200.46.208.106]) by mail.postgresql.org (Postfix) with ESMTP id 9EB9D633B5A for ; Tue, 31 Mar 2009 00:59:42 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mail.cult.cu (mail.cult.cu [200.0.24.2]) by mx1.hub.org (Postfix) with ESMTP id D5DB61259E74 for ; Tue, 31 Mar 2009 00:59:41 -0300 (ADT) Received: from [200.0.25.90] (helo=ciego.cult.cu) by mail.cult.cu with esmtp (Exim 4.34) id 1LoV6k-0002Ig-2a for pgsql-admin@postgresql.org; Mon, 30 Mar 2009 23:57:50 -0400 Received: from atenea by ciego.cult.cu (MDaemon PRO v9.6.2) with ESMTP id md50000112991.msg for ; Tue, 31 Mar 2009 00:00:10 -0400 Message-ID: <006d01c9b183$09470050$3000a8c0@atenea> From: =?iso-8859-1?Q?F=E9lix_S=E1nchez_Rodr=EDguez?= To: Subject: Data type to store files Date: Tue, 31 Mar 2009 00:01:09 +0200 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_006A_01C9B193.CBD2F9C0" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.2180 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 X-Authenticated-Sender: fesanch@ciego.cult.cu X-Spam-Processed: ciego.cult.cu, Tue, 31 Mar 2009 00:00:10 -0400 (not processed: spam filter heuristic analysis disabled) X-MDRemoteIP: 192.168.0.48 X-Return-Path: fesanch@ciego.cult.cu X-Envelope-From: fesanch@ciego.cult.cu X-MDaemon-Deliver-To: pgsql-admin@postgresql.org X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.395 tagged_above=0 required=5 tests=DATE_IN_PAST_03_06=1.394, HTML_MESSAGE=0.001 X-Spam-Level: * X-Archive-Number: 200903/254 X-Sequence-Number: 31754 This is a multi-part message in MIME format. ------=_NextPart_000_006A_01C9B193.CBD2F9C0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable 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 ------=_NextPart_000_006A_01C9B193.CBD2F9C0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Greetings:
 
I need to use a PostgreSQL Data Base to = store=20 different kinds of files, eg: images, videos. So, I'm wondering what = data type=20 should I use.
 
Tbanks in = advance
------=_NextPart_000_006A_01C9B193.CBD2F9C0-- From agustingenoves@gmail.com Tue Mar 31 11:31:51 2009 Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 47AFA634236 for ; Tue, 31 Mar 2009 08:31:51 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 85532-05 for ; Tue, 31 Mar 2009 08:31:39 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-qy0-f115.google.com (mail-qy0-f115.google.com [209.85.221.115]) by mail.postgresql.org (Postfix) with ESMTP id 29033633FC3 for ; Tue, 31 Mar 2009 08:31:45 -0300 (ADT) Received: by qyk13 with SMTP id 13so4663805qyk.15 for ; Tue, 31 Mar 2009 04:31:43 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:in-reply-to:references :date:message-id:subject:from:to:cc:content-type :content-transfer-encoding; bh=UtFjOgH8DddzKYPNCivahvJgKjpW4v3QUXt5JYs8nm4=; b=fRMDQ7WxO/cG5pel4KLPc/So9R8HGD6/SlsrHtpgoIxtIHgLiOo9l1aQSj2HJqTpRz +9oi2BFT2ApxTmDcxIPF25MVYXoQxscocmCyqsvAczFt1l0JwIkWv4yyaYn/inQ84hpI j/OpUWml5djPHIbEZytLYHVCGSZNpXcFmgHZE= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type:content-transfer-encoding; b=Dplk3OvoxHNs7ZW9w0kyn/cJp+wLypGh7RuglcLOthuR5APfV/4La2uQGQCNK4lefS unod8RzhuICWlYBXi1VryoroLBOC+P8Iv0OKmAHb7Pu8mn1UqdCAYqc3DyP4yeuy68YB Peu202EZmSIhSudeQvSKRJwxzEwpCi9iS/yg0= MIME-Version: 1.0 Received: by 10.229.82.68 with SMTP id a4mr2283978qcl.18.1238499103632; Tue, 31 Mar 2009 04:31:43 -0700 (PDT) In-Reply-To: <006d01c9b183$09470050$3000a8c0@atenea> References: <006d01c9b183$09470050$3000a8c0@atenea> Date: Tue, 31 Mar 2009 08:31:43 -0300 Message-ID: Subject: Re: Data type to store files From: Agustin Ignacio Genoves To: =?ISO-8859-1?Q?F=E9lix_S=E1nchez_Rodr=EDguez?= Cc: pgsql-admin@postgresql.org Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable 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/259 X-Sequence-Number: 31759 I guess you should use Bytea El d=EDa 30 de marzo de 2009 19:01, F=E9lix S=E1nchez Rodr=EDguez escribi=F3: > Greetings: > > I need to use a PostgreSQL Data Base to store different kinds of files, e= g: > images, videos. So, I'm wondering what data type should I use. > > Tbanks in advance From postgresql@tisc.de Tue Mar 31 12:35:07 2009 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