pg_dumap not include foreign key... - Mailing list pgsql-admin

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

);

���R�W�����^ �� �O �� �H �� �~�ȥD���G�� �� �t�A�ȱM�u�G0932-535772
mailto:msee@kimo.com.tw