Re: Postgresql 8.0.2 et stockage des images

From: "FERREIRA, William (COFRAMI)" <william(dot)ferreira(at)airbus(dot)com>
To: francois(at)moinel(dot)org, pgsql-fr-generale(at)postgresql(dot)org
Subject: Re: Postgresql 8.0.2 et stockage des images
Date: 2005-05-09 06:46:54
Message-ID: 414D259CE29DE54DAD534037C83CE4B7264D3E@FR0-MAILMB20.res.airbus.corp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-fr-generale

je pense que le mieux est d'avoir une table de type
table client(
nomClient VARCHAR(50)
nomPhoto VARCHAR(50);
photo OID
)
et d'importer et exporter les photos avec les methodes lo_export et lo_import

-----Message d'origine-----
De : pgsql-fr-generale-owner(at)postgresql(dot)org
[mailto:pgsql-fr-generale-owner(at)postgresql(dot)org]De la part de Francois
MOINEL
Envoy : dimanche 8 mai 2005 12:02
: pgsql-fr-generale(at)postgresql(dot)org
Objet : [pgsql-fr-generale] Postgresql 8.0.2 et stockage des images

Bonjour

J'utilise Delphi 7 pro et Postgresql 8.0.2 et les composant Microolap.
J'ai une table client. Je dois stocker la photo du client environ 50 Ko
Maxi.
Avez-vous une exprience dans ce domaine ?

Dois-je :
Stocker le chemin du rpertoire + le nom de la photo ex :
c:\photos\Idclient.jpg dans un varchar ?
Stocker ma photo dans un blob ?

Merci pour vos ides

Francois MOINEL
Strasbourg

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

This mail has originated outside your organization,
either from an external partner or the Global Internet.
Keep this in mind if you answer this message.

This e-mail is intended only for the above addressee. It may contain
privileged information. If you are not the addressee you must not copy,
distribute, disclose or use any of the information in it. If you have
received it in error please delete it and immediately notify the sender.
Security Notice: all e-mail, sent to or from this address, may be
accessed by someone other than the recipient, for system management and
security reasons. This access is controlled under Regulation of
Investigatory Powers Act 2000, Lawful Business Practises.

Responses

Browse pgsql-fr-generale by date

  From Date Subject
Next Message Guillaume LELARGE 2005-05-09 06:55:28 Re: Traduction du manuel de PostgreSQL
Previous Message Jean-Christophe Arnu 2005-05-09 06:38:07 Re: sql_ascii et latin1