Search Postgresql Archives

"oracle to postgresql" conversion

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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!



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux