Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
Lists: pgsql-docs

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.




pgsql-docs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2018 The PostgreSQL Global Development Group