Thread: Blob like type

Doing a move over from MySQL and I was wondering if there anything like the
MySQL blob 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)

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

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)

How about lo type in contrib/lo?


Kenji Sugita
sugita@sra.co.jp