> Is it possible to store a gif or jpg image
> in a PG database, then retrieve the image
> and display it on a web page?
>
> If so, how do you create the table?
>
> -Thanks
To propose something horribly simple and direct, perhaps it would
make more sense to actually just store the files on disk
I got an error when accessing a view. The view looks like this:
CREATE TABLE ar_contacts(
contact_seq int,
update_date date,
period date,
paidfloat,
sales float,
last_date date,
due fl
> On Wed, 13 Jan 1999, Jackson, DeJuan wrote:
>
> > And remember unless you use full text indexing (which is
> expensive) you
> > won't have indexing on that search (for either the LIKE or regex).
> > -DEJ
>
> Actually, if you use case sensitive regex, and anchor the
> begining (with
> ^)
On Wed, 13 Jan 1999, Jackson, DeJuan wrote:
> And remember unless you use full text indexing (which is expensive) you
> won't have indexing on that search (for either the LIKE or regex).
> -DEJ
Actually, if you use case sensitive regex, and anchor the begining (with
^) then it will use btr
> Hi,
>
> I want to use Perl with DBI(DataBase Independent Interface) to write cgi
> scripts.
> In /src/interfaces/perl5 directory, I found Pg. But my friend told me that Pg
> isn't DBI. Now I'm confused. Pg is DBI or not?
> If not, how can I install Postgres DBI?
>
> -Kevin.
Go to CPAN mirror n
Hi,
I want to use Perl with DBI(DataBase Independent Interface) to write cgi
scripts.
In /src/interfaces/perl5 directory, I found Pg. But my friend told me that Pg
isn't DBI. Now I'm confused. Pg is DBI or not?
If not, how can I install Postgres DBI?
-Kevin.
Now that I've stored several jpg's in my
database as large objects, I'm trying to
display them on a web page using a java servlet.
Im my servlet, I've changed the content type
to image/jpeg - response.setContentType("image/jpg");
When the web page is loaded, all I see is the ID
number of the imag