pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Julien Cigar <jcigar@ulb.ac.be>
To: pgsql-sql@postgresql.org
Subject: Re: column type for pdf file
Date: Wed, 18 May 2011 22:46:23 +0200
Message-ID: <4DD4301F.4010403@ulb.ac.be> (raw)
In-Reply-To: <4DD42A1C.30202@encs.concordia.ca>
References: <4DD42A1C.30202@encs.concordia.ca>

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
>

Attachments:

  [text/x-vcard] jcigar.vcf (252B, ../4DD4301F.4010403@ulb.ac.be/2-jcigar.vcf)
  download | inline:
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

view thread (14+ messages)  latest in thread

Message-ID: <4DD4301F.4010403@ulb.ac.be>
Permalink:  ../4DD4301F.4010403@ulb.ac.be/
Also on:    postgresql.org/message-id/4DD4301F.4010403@ulb.ac.be

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: jcigar@ulb.ac.be
  Subject: Re: column type for pdf file
  In-Reply-To: <4DD4301F.4010403@ulb.ac.be>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox