Heroku Blob does not exist

Question

If Heroku Postgres does not allow blob, what should I use to store binary data?

2012-05-30T05:59:36+00:00 app[web.1]: [debug] cjbStatementHandle - create table image_info ( 2012-05-30T05:59:36+00:00 app[web.1]: id bigint not null, 2012-05-30T05:59:36+00:00 app[web.1]: image_id varchar(255), 2012-05-30T05:59:36+00:00 app[web.1]: subject_id varchar(255), 2012-05-30T05:59:36+00:00 app[web.1]: web_thumbnail blob, 2012-05-30T05:59:36+00:00 app[web.1]: created_date timestamp, 2012-05-30T05:59:36+00:00 app[web.1]: image blob, 2012-05-30T05:59:36+00:00 app[web.1]: thumbnail blob, 2012-05-30T05:59:36+00:00 app[web.1]: constraint pk_image_info primary key (id)) 2012-05-30T05:59:36+00:00 app[web.1]: [debug] cjbPreparedStatementHandle - update play_evolutions set last_problem = 'ERROR: type "blob" does not exist 2012-05-30T05:59:36+00:00 app[web.1]: Position: 176 [ERROR:0, SQLSTATE:42704]' where id = 1 

Answer 1

Use bytea , blob is not a PostgreSQL data type.