Insert ImageFile in PostgreSQL

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
5 messages Options
Reply | Threaded
Open this post in threaded view
|

Insert ImageFile in PostgreSQL

johan giant
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.
Reply | Threaded
Open this post in threaded view
|

Re: Insert ImageFile in PostgreSQL

Silas Justiniano
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
Reply | Threaded
Open this post in threaded view
|

Re: Insert ImageFile in PostgreSQL

Oluwatope Akinniyi-2
In reply to this post by johan giant
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

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to [hidden email] so that your
       message can get through to the mailing list cleanly
Reply | Threaded
Open this post in threaded view
|

Re: Insert ImageFile in PostgreSQL

Tino Wildenhain
In reply to this post by Silas Justiniano
Am Dienstag, den 02.08.2005, 08:52 -0700 schrieb [hidden email]:
> 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 <[hidden email]>


---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

               http://archives.postgresql.org
Reply | Threaded
Open this post in threaded view
|

Re: Insert ImageFile in PostgreSQL

Reid Thompson
In reply to this post by Silas Justiniano
[hidden email] 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.

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq