Oracle -> PostgreSQL ==> RAW -> ???

From: Ezra Epstein <akee(at)speakeasy(dot)net>
To: pgsql-docs(at)postgresql(dot)org
Subject: Oracle -> PostgreSQL ==> RAW -> ???
Date: 2001-11-21 15:32:04
Message-ID: 200111211532.fALFW4721515@spidey.speakeasy.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

Hi,

I'm moving a database from Oracle to PostgreSQL. I use RAW (as in BINARY, as in BYTE(x) where x < 20) for quite a few columns that hold application generated keys, etc.

How do I represent a RAW in PostgreSQL. I'm too much of a newbie to know how to create my own type. BIT seems to be wrong. And BYTEA can't be it either as there are all sorts of restrictions on using BYTEAs for keys. Seems OIDs are for BLOBs and this are not large binary objects...

HELP!!! Answers, pointers, tips, doc refs, anything.

Thanks,

EE

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Joe Conway 2001-11-21 17:04:41 Re: [PATCHES] PQescapeBytea documentation patch
Previous Message Patrick Welche 2001-11-21 12:25:55 Re: [PATCHES] PQescapeBytea documentation patch