Re: Image data type equivalent in postgresql

From: Mike Mascari <mascarm(at)mascari(dot)com>
To: Josué Maldonado <josue(at)lamundial(dot)hn>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Image data type equivalent in postgresql
Date: 2003-09-18 20:43:39
Message-ID: 3F6A18FB.1020305@mascari.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)mascari(dot)com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message scott.marlowe 2003-09-18 20:54:54 Re: Scalability (both vertical and horizontal)?
Previous Message Mike Mascari 2003-09-18 20:41:29 Re: PostgreSQL versus MySQL