MySQL --> PSQL (Schema anpassen)

Es gibt viele Wege nach Rom:

test=# create table t1 (id int primary key);
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "t1_pkey" for table "t1"
CREATE TABLE
Zeit: 2,336 ms
test=*# create table t2 (i int references t1);
CREATE TABLE
Zeit: 1,613 ms
test=*# create table t3 (i int, foreign key (i) references t1(id));
CREATE TABLE
Zeit: 1,564 ms
test=*# create table t4 (i int);
CREATE TABLE
Zeit: 0,833 ms
test=*# alter table t4 add foreign key (i) references t1(id) on delete cascade;
ALTER TABLE
Zeit: 2,548 ms

Andreas