From: Sascha Ziemann <ziemann@secunet.de>
To: pgsql-sql@postgresql.org
Subject: CREATE TYPE VARCHAR2
Date: 23 Aug 2004 19:08:03 +0200
Message-ID: <m33c2dkcjw.fsf_-_@sn-e0310.ek.secunet.de> (raw)
In-Reply-To: <m3hdrcps0y.fsf@sn-e0310.ek.secunet.de>
Hi,
I try to emulate with PostgreSQL an Oracle database. My problem is
that PostgreSQL does not support any Oracle specific types.
PostgreSQL provides the TEXT and Oracle uses the CLOB or VARCHAR2
type. I would like to use the CREATE TYPE statement to tell
PostgreSQL about the Oracle types, but the documentation does not
describe how to define a simple alias type. I would like to define a
new type VARCHAR2 which should behave exactly like VARCHAR. Is this
possible with PostgreSQL? By this it would be possible to run the
Oracle create table scripts without modification.
cu Sascha
--
secunet Security Networks AG, Im Teelbruch 116, 45219 Essen
Tel: +49-2054-123-408 Fax: +49-2054-123-123
PGP: FBE2 A49B 6526 C1B4 7F10 24E4 5004 7C27 6E9A 9698
Besuchen Sie uns auf der DMS-Expo vom 07. - 09. September 2004 in
Essen, Halle 2, Stand 2435 c/d (Consulting Corner).
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: ziemann@secunet.de
Subject: Re: CREATE TYPE VARCHAR2
In-Reply-To: <m33c2dkcjw.fsf_-_@sn-e0310.ek.secunet.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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