Image data type equivalent in postgresql

Started by Josué Maldonadoover 22 years ago2 messagesgeneral
Jump to latest
#1Josué Maldonado
josue@lamundial.hn

Hello list,

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

TIA,

--
Josu� Maldonado.

#2Mike Mascari
mascarm@mascari.com
In reply to: Josué Maldonado (#1)
Re: Image data type equivalent in postgresql

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