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

You should have another lines later in the dump that start
with CREATE CONSTRAINT TRIGGER
These are the internal representation of the foreign key
constraint and is how pg_dump[all] currently should be
dumping those constraints out.  They probably are near
the bottom of the dump.

On Mon, 25 Dec 2000, xyzii wrote:

> 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
>
> );