pg_dumap not include foreign key...

me datastru ,try pg_dumpall > aa.out what not include foreign key......

CREATE TABLE "purcsub" (
"trn_no" char(14) NOT NULL,
"seq" int4 DEFAULT nextval('seq'::text),
"pmrc_no" varchar(14),
"item_no" char(20) NOT NULL,
"item_na1" varchar(120),
"color_na" varchar(20),
"ware_no" char(4),
"unit" varchar(4),
"trn_qty" int2,
"qty" float8 default 0,
"sqty" float8 default 0,
"price" float8 default 0,
"sprice" float8 default 0,
"discount" float8 default 0,
"amount" float8 default 0,
"memo" varchar(20),
"trn_type" varchar(2),
"trn_date" date,
"fact_no" char(20),
"giveaway" varchar(1),
foreign key (trn_no) references purc (trn_no)
ON DELETE CASCADE ON UPDATE CASCADE

);

RW^ O H ~DG tAMuG0932-535772
mailto:msee(at)kimo(dot)com(dot)tw