pg.ddx.io pgsql-docs@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Oracle -> PostgreSQL ==> RAW -> ??? 2+ messages / 2 participants [nested] [flat]
* Oracle -> PostgreSQL ==> RAW -> ??? @ 2001-11-21 15:32 Ezra Epstein <akee@speakeasy.net> 2001-11-21 17:12 ` Re: Oracle -> PostgreSQL ==> RAW -> ??? Joe Conway <joseph.conway@home.com> 0 siblings, 1 reply; 2+ messages in thread From: Ezra Epstein @ 2001-11-21 15:32 UTC (permalink / raw) To: 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 ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Oracle -> PostgreSQL ==> RAW -> ??? 2001-11-21 15:32 Oracle -> PostgreSQL ==> RAW -> ??? Ezra Epstein <akee@speakeasy.net> @ 2001-11-21 17:12 ` Joe Conway <joseph.conway@home.com> 0 siblings, 0 replies; 2+ messages in thread From: Joe Conway @ 2001-11-21 17:12 UTC (permalink / raw) To: Ezra Epstein <akee@speakeasy.net>; +Cc: pgsql-docs Ezra Epstein wrote: > 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. Most of the BYTEA restrictions are gone in 7.2 (about to go into 3rd beta release). Specifically, you can now create btree indexes on BYTEA columns. There's documentation too, in CVS and starting with beta3. Look for "Binary Strings" under the section on datatypes and functions. Hope this helps, Joe ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2001-11-21 17:12 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2001-11-21 15:32 Oracle -> PostgreSQL ==> RAW -> ??? Ezra Epstein <akee@speakeasy.net> 2001-11-21 17:12 ` Joe Conway <joseph.conway@home.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox