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.
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 |