dump of dictionary

From: Feite Brekeveld <feite(dot)brekeveld(at)osiris-it(dot)nl>
To: pgsql-general(at)postgresql(dot)org
Subject: dump of dictionary
Date: 2001-02-17 20:38:47
Message-ID: 3A8EE157.6E34E35@osiris-it.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Richardson 2001-02-17 20:40:20 Re: Function reference
Previous Message Michelle Murrain 2001-02-17 19:49:36 troublesome inputs