bytea or large object

From: Jean-Christophe FABRE <jean-christophe(dot)fabre(at)ensam(dot)inra(dot)fr>
To: pgsql-sql(at)postgresql(dot)org, pgsql-php(at)postgresql(dot)org
Subject: bytea or large object
Date: 2002-04-03 14:47:29
Message-ID: 5.0.0.25.0.20020403164135.00ad0380@ensam.inra.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-php pgsql-sql


Hi,

I would like to store .pdf files in a database, which is accessed through a
PHP interface.
which is the best way to store binary data?
- bytea? (with the tricky handling of escape chars)
- large objects?

thanks

JC

PS: I didn't found any example of scripts using bytea in PHP, does someone
has some?

_________________________________________________________
Jean-Christophe FABRE
INRA - UMR Sol & Environnement tel: +33 (0)4 99 61 23 51
2, place Viala fax: +33 (0)4 67 63 26 14
34060 MONTPELLIER cedex 1
FRANCE

Responses

Browse pgsql-php by date

  From Date Subject
Next Message Timothy_maguire 2002-04-03 14:48:06 Re: bytea or large object
Previous Message Joe Conway 2002-04-01 21:22:05 Re: How to send bytea data straight to browser (as in pg_loreadall)?

Browse pgsql-sql by date

  From Date Subject
Next Message Timothy_maguire 2002-04-03 14:48:06 Re: bytea or large object
Previous Message cristi69 2002-04-03 06:12:43 Date