Re: How to insert gif file into Postgres database?

Mariusz, Lemme think ... 1. Have you tried storing the image from the PSQL command line and does it work? If so have you retrieved it and is the retrieval time acceptable? 2. You might be hitting PGSQL's limit on row size - I thought it was about 8k bytes. 3. Storing an image in a file, although good in theory, often doesn't work well in practice. Retrieval tends to be slow. 4. Common practice is to store the image in directory and store the location of the image in the database. Regards - Miles Thompson Mariusz Topczewski wrote: > Hi, > > I can't insert gif file into postgres's database. If I use pg_lowrite() > function to insert text file , it works! I cen display text file on my Web > page, but when I try to insert gif file, I can't see picture on Web page. > (I change header on image/gif) > > Please, help me, > Best regards, > Mariusz Topczewski > > P.S. Is the pg_loimport() function defined? If I try to use this function, I > have error ".. call to undefined function"? > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net