Blob like type
On Sun, Jun 23, 2002 at 11:54:24AM -0700, Patrick Nelson wrote:
Doing a move over from MySQL and I was wondering if there anything like the
MySQL blob type?
Try BYTEA:
http://developer.postgresql.org/docs/postgres/datatype-binary.html
Cheers,
Neil
--
Neil Conway <neilconway@rogers.com>
PGP Key ID: DB3C29FC
There are several options, including bytea for binary data, large objects, and
if you can encode the data as text you can store it in a plain text field of
arbitrary size. Each option has its own set of pros and cons. You might want to
describe exactly how you want to use it to get more specific advice.
Wes
Patrick Nelson <pnelson%neatech.com@interlock.lexmark.com> on 06/23/2002
02:54:24 PM
To: "PostgreSQL List (E-mail)"
<pgsql-general%postgresql.org@interlock.lexmark.com>
cc: (bcc: Wesley Sheldahl/Lex/Lexmark)
Subject: [GENERAL] Blob like type
Doing a move over from MySQL and I was wondering if there anything like the
MySQL blob type?
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
Import Notes
Resolved by subject fallback
You're probably looking for either "text", "bytea", or possibly the large
object interface. If you have binary data use bytea, otherwise use text.
Both bytea and text are unlimited in size. Text automatically compresses the
contents.
Regards,
Jeff
Show quoted text
On Sunday 23 June 2002 11:54 am, Patrick Nelson wrote:
Doing a move over from MySQL and I was wondering if there anything like the
MySQL blob type?---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
