| From: | Kenneth Marshall <ktm(at)rice(dot)edu> |
|---|---|
| To: | "Bill P(dot)" <maxarbos(at)yahoo(dot)com> |
| Cc: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: Datatype for MySQL Varbinary |
| Date: | 2010-12-14 21:45:17 |
| Message-ID: | 20101214214517.GJ10252@aart.is.rice.edu |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
On Tue, Dec 14, 2010 at 01:25:16PM -0800, Bill P. wrote:
> Hello,
>
> I am in the process of migrating a mysql db to a postgresql one and there are a
> few tables with columns with datatypes of 'Varbinary'
> These columns store the AES_ENCRYPTed output of a value.
>
> What datatype should I set the postgresql table.column to for this to be stored
> properly?
>
>
> I cannot decrypt the data and re-encrypt it into postgres, so the format and
> content need to remain the same on migration.
>
> Thank you.
>
BYTEA:
http://www.postgresql.org/docs/9.0/static/datatype-binary.html
Cheers,
Ken
| From | Date | Subject | |
|---|---|---|---|
| Next Message | JORGE MALDONADO | 2010-12-14 23:07:33 | Getting tables from one DB to another |
| Previous Message | Bill P. | 2010-12-14 21:25:16 | Datatype for MySQL Varbinary |