[GENERAL] dump of dictionary

[Feite Brekeveld]

Hi,

Is there a way to get a dictionary back in the (or almost the) same way
the database is created ?

When defining:

create table xxx (
   id varchar(10) not null,
   blabla varchar(100)
);


create table refxx (
   id varchar(10) not null,
   other values ...

  primary key(id),
  foreign key(id) references xxx(id)
);


After a pg_dump you get a file with the definition of triggers that were
a result of the foreign key part in the table definition. When having a
complex database the file becomes almost unreadable.

Is there a way to get the dictionary back in the way as stated above ?


Thanks,

Feite Brekeveld