Received: from spidey.speakeasy.net (webmail.speakeasy.net [216.254.0.16])
	by postgresql.org (8.11.3/8.11.4) with ESMTP id fALFX6m43252
	for <pgsql-docs@postgresql.org>; Wed, 21 Nov 2001 10:33:06 -0500 (EST)
	(envelope-from akee@speakeasy.net)
Received: (from nobody@localhost)
	by spidey.speakeasy.net (8.11.6/8.11.2) id fALFW4721515;
	Wed, 21 Nov 2001 07:32:04 -0800
Message-Id: <200111211532.fALFW4721515@spidey.speakeasy.net>
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
Content-Type: text/plain
MIME-Version: 1.0
Date: Wed, 21 Nov 2001 07:32:04 -0800
From: Ezra Epstein <akee@speakeasy.net>
To: pgsql-docs@postgresql.org
Subject: Oracle -> PostgreSQL ==>  RAW -> ???
X-Sender: akee@speakeasy.net
X-Originating-Ip: [64.81.50.187]
X-Mailer: Speakeasy Network Webmail 2.1.0
X-Archive-Number: 200111/60
X-Sequence-Number: 1133

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