"oracle to postgresql" conversion - Mailing list pgsql-general

From altudela@gmail.com
Subject "oracle to postgresql" conversion
Date
Msg-id 1173200515.488506.140000@h3g2000cwc.googlegroups.com
Whole thread Raw
Responses Re: "oracle to postgresql" conversion  (Kevin Hunter <hunteke@earlham.edu>)
Re: "oracle to postgresql" conversion  (Scott Marlowe <smarlowe@g2switchworks.com>)
List 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!


pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: Tabulate data incrementally
Next
From: Harald Fuchs
Date:
Subject: Re: Importing *huge* mysql database into pgsql