Re: Equivalent of mysql type mediablob in postgres?

From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Equivalent of mysql type mediablob in postgres?
Date: 2010-01-18 20:09:59
Message-ID: hj2f6m$jbu$1@ger.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Chris Barnes wrote on 18.01.2010 21:05:
>
>
> I would like to move a table that is used to store images from mysql to
> postgres. The only stumbling I may encounter, may be switching from
> mysql blob to something in postgres.
>
> We store chart images in a mysql medium blob type.
>
> How can I store these in postgres?

bytea is the datatype you are looking for

http://www.postgresql.org/docs/current/static/datatype-binary.html

Thomas

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2010-01-18 20:20:22 Re: Updating from a column
Previous Message Chris Barnes 2010-01-18 20:05:59 Equivalent of mysql type mediablob in postgres?