dump of dictionary - Mailing list pgsql-general

From Feite Brekeveld
Subject dump of dictionary
Date
Msg-id 3A8EE157.6E34E35@osiris-it.nl
Whole thread Raw
Responses Re: dump of dictionary  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
List 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


pgsql-general by date:

Previous
From: David Wheeler
Date:
Subject: Re: Case insensitive selects?
Next
From: "Matt Friedman"
Date:
Subject: Re: SELECT (sometimes) returning Zero Rows? Fixed, sort of...