Re: Blob like type

From: Jeff Davis <list-pgsql-general(at)empires(dot)org>
To: Patrick Nelson <pnelson(at)neatech(dot)com>, "PostgreSQL List (E-mail)" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Blob like type
Date: 2002-06-24 18:54:11
Message-ID: 200206241855.LAA11558@smtp.ucsd.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)postgresql(dot)org)

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Marc G. Fournier 2002-06-24 19:13:02 Proxy Server ...
Previous Message Pablo Morales 2002-06-24 18:24:58 initdb