CREATE TYPE VARCHAR2

From: Sascha Ziemann <ziemann(at)secunet(dot)de>
To: pgsql-sql(at)postgresql(dot)org
Subject: CREATE TYPE VARCHAR2
Date: 2004-08-23 17:08:03
Message-ID: m33c2dkcjw.fsf_-_@sn-e0310.ek.secunet.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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).

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Joe Conway 2004-08-23 18:32:44 Re: array_in: '{}}'::text[]
Previous Message Cavit Keskin 2004-08-23 15:12:02 TSearch2 other languages