Re: [GENERAL] Data type for storing images?
On Sun, Mar 11, 2001 at 08:48:21PM -0500, Tom Lane wrote: [ . . . ] bytea is probably your best bet. The 8k limit is toast in 7.1, btw. Is that whay you named it TOAST, in order to be able to say that? :))) Regards, Frank ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
[GENERAL] Data type for storing images?
I would like to store some images in my Postgres database. These will all be thumbnails, limited to 4k or 5k. I know that PG has an 8k row limit, but this should be fine, because there's not much else in the row. Which data type could I use to store them, and is there a performance cost for having rows that are this big? The system will be using PG7.1, btw. Thanks ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [GENERAL] Data type for storing images?
[EMAIL PROTECTED] writes: I would like to store some images in my Postgres database. These will all be thumbnails, limited to 4k or 5k. I know that PG has an 8k row limit, but this should be fine, because there's not much else in the row. Which data type could I use to store them, and is there a performance cost for having rows that are this big? The system will be using PG7.1, btw. bytea is probably your best bet. The 8k limit is toast in 7.1, btw. regards, tom lane ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [GENERAL] Data type for storing images?
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 ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])