Re: Image data type equivalent in postgresql - Mailing list pgsql-general

Josué Maldonado wrote:

> Hello list,
>
> That's the question, what is the equivalent data type of the msSQL image
> data type ?

You can use 'bytea' for binary data. You can use 'text' and base64
encode the image before insertion. You can, of course, create your own
 'image' type using CREATE TYPE.  You could also alias the 'bytea'
type via CREATE DOMAIN.

HTH,

Mike Mascari
mascarm@mascari.com