Re: Data type for storing images?

From: "David Wall" <d(dot)wall(at)computer(dot)org>
To: <drevil(at)sidereal(dot)kz>, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Data type for storing images?
Date: 2001-03-12 02:12:29
Message-ID: 001701c0aa99$e419fb00$5a2b7ad8@expertrade.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-interfaces

> bytea is probably your best bet. The 8k limit is toast in 7.1, btw.

If you're using JDBC, you may not be able to get bytea types to work. I was
able to get the SQL type OID to work with JDBC's get/setBytes() methods.
You may also want to use 7.1 since I believe it's large object support is
improved.

David

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bill Huff 2001-03-12 06:32:33 Poor Delete performance
Previous Message datactrl 2001-03-12 02:12:16 psql win32 version?

Browse pgsql-interfaces by date

  From Date Subject
Next Message David Ward 2001-03-12 02:36:32 Generic Driver
Previous Message Tom Lane 2001-03-12 01:48:21 Re: Data type for storing images?