dump of dictionary

Поиск
Список
Период
Сортировка
От Feite Brekeveld
Тема dump of dictionary
Дата
Msg-id 3A8EE157.6E34E35@osiris-it.nl
обсуждение исходный текст
Ответы Re: dump of dictionary
Список 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 по дате отправления:

Предыдущее
От: David Wheeler
Дата:
Сообщение: Re: Case insensitive selects?
Следующее
От: "Matt Friedman"
Дата:
Сообщение: Re: SELECT (sometimes) returning Zero Rows? Fixed, sort of...