"oracle to postgresql" conversion

From: altudela(at)gmail(dot)com
To: pgsql-general(at)postgresql(dot)org
Subject: "oracle to postgresql" conversion
Date: 2007-03-06 17:01:55
Message-ID: 1173200515.488506.140000@h3g2000cwc.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I'm a newbie in Oracle and postgreSQL,
i'm need to translate the following script (in Oracle) to postgreSQL :

rem Autorisation des lignes vides :
set sqlbl on

rem Initialisation du timer :
set timing on

rem Creation de la table :

CREATE TABLE "LEPAPE"."EXPERIENCE"(
"EXP_ID" VARCHAR2(16) NOT NULL,
"MEASURE" VARCHAR2(10) NOT NULL,
"THRESHOLD" NUMBER NOT NULL,
"NB_NODES" NUMBER(3) NOT NULL,
"TOTAL_TIME" VARCHAR2(10) NOT NULL,
"SC_ID" NUMBER(6) NOT NULL,
"GRANULARITY" VARCHAR2(10) NOT NULL,

CONSTRAINT "SYS_C009967" CHECK(measure in ('age', 'num','order')))

Thanks!

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Laurent ROCHE 2007-03-06 17:02:47 Re : Importing *huge* mysql database into pgsql
Previous Message Chris Browne 2007-03-06 16:53:05 Re: Importing *huge* mysql database into pgsql