table1에 있는
[table 1]
"nr" int4 DEFAULT NOT NULL,
"bid" int4 DEFAULT NULL,
"thread" numeric DEFAULT NULL,
"id" text DEFAULT NULL,
"nick" text DEFAULT NULL,
"passwd" text DEFAULT NULL,
"cdate" timestamp DEFAULT NULL,
"modify_time" timestamp DEFAULT NULL,
"subject" text DEFAULT NULL,
"email" text DEFAULT NULL,
"link" text[] DEFAULT NULL,
"body" text DEFAULT NULL,
"adminflag" int4 DEFAULT NULL,
"hit" int4 DEFAULT NULL,
"cmt" int4 DEFAULT NULL,
"last_comment" timestamp DEFAULT NULL,
"filename" numeric[] DEFAULT NULL,
"filesize" int4[] DEFAULT NULL,
"pseudo" text[] DEFAULT NULL,
"down" int4 DEFAULT NULL,
"ip" inet DEFAULT NULL,
"secret" int2 DEFAULT 0,
"mime" int2 DEFAULT NULL,
"top" int2 DEFAULT NULL,
CONSTRAINT "table 1" PRIMARY KEY ("nr")
)
WITH (OIDS=FALSE);
CREATE TABLE "table 2" (
"nr" int4 DEFAULT nextval NOT NULL,
"bid" int4 DEFAULT NULL,
"category" int4 DEFAULT NULL,
"thread" numeric DEFAULT NULL,
"id" text DEFAULT NULL,
"nick" text DEFAULT NULL,
"passwd" text DEFAULT NULL,
"cdate" timestamp DEFAULT NULL,
"modify_time" timestamp DEFAULT NULL,
"subject" text DEFAULT NULL,
"email" text DEFAULT NULL,
"link" text[] DEFAULT NULL,
"body" text DEFAULT NULL,
"adminflag" int4 DEFAULT NULL,
"hit" int4 DEFAULT NULL,
"cmt" int4 DEFAULT NULL,
"last_comment" timestamp DEFAULT NULL,
"filename" numeric[] DEFAULT NULL,
"filesize" int4[] DEFAULT NULL,
"pseudo" text[] DEFAULT NULL,
"down" int4 DEFAULT NULL,
"ip" inet DEFAULT NULL,
"secret" int2 DEFAULT 0,
"mime" int2 DEFAULT NULL,
"top" int2 DEFAULT NULL,
"recommand" int4 DEFAULT NULL,
"ximg" text[] DEFAULT NULL,
"edit" int4 DEFAULT NULL,
"ext1" int4[] DEFAULT NULL,
"ext2" text[] DEFAULT NULL,
"ext3" timestamp[] DEFAULT NULL,
"tmpsubj" text DEFAULT NULL,
"tmpbody" text DEFAULT NULL,
CONSTRAINT "table2" PRIMARY KEY ("nr")
)
WITH (OIDS=FALSE);
어떻게 옮기면 좋을까요....ㅠㅠ |