By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,749 Members | 1,627 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,749 IT Pros & Developers. It's quick & easy.

Image data type equivalent in postgresql

P: n/a
Hello list,

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

TIA,

--
Josué Maldonado.
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postgresql.org so that your
message can get through to the mailing list cleanly

Nov 11 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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
ma*****@mascari.com

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Nov 11 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.