Thread: Insert ImageFile in PostgreSQL
Please help me!!!
Howto insert images file from Visual basic 6 into postgreSQL database server
For information :
my database server : Fedora Core 2
my client : Win XP Pro SP #2 with visual basic 6.
thanks be4.
Yahoo! Mail for Mobile
Take Yahoo! Mail with you! Check email on your mobile phone.
Johan, Try the link below for a sample project clip which you should customise for PostgreSQL. If you need further assistance feel free to contact me. http://www.shepherdhill.biz/downloads/image.zip Cheers. Tope Akinniyi CEO ShepherdHill Software Lagos, Nigeria
I'm sorry, but I know only the basics about DBMs, but I think is not possible to put a image file INSIDE a database. You can put in a database the path of the file... (Maybe I'm wrong...) See ya!
Am Dienstag, den 02.08.2005, 08:52 -0700 schrieb silasju@gmail.com: > I'm sorry, but I know only the basics about DBMs, but I think is not > possible to put a image file INSIDE a database. You can put in a > database the path of the file... > > (Maybe I'm wrong...) sorry to say that, but indeed you are ;) Postgres has 2 ways to accomplish this: one is to use large objects (lo) which is a bit painfull with the interface and w/ backups. the other is just to store the file data in a bytea field, which is limited in size (1GB) and requires you to fetch the complete file data at once. -- Tino Wildenhain <tino@wildenhain.de>
silasju@gmail.com wrote: >I'm sorry, but I know only the basics about DBMs, but I think is not >possible to put a image file INSIDE a database. You can put in a >database the path of the file... > >(Maybe I'm wrong...) > >See ya! > > >---------------------------(end of broadcast)--------------------------- >TIP 3: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faq > > See the postgresql org docs for the bytea datatype.