RE: Table/Column Constraints

Поиск
Список
Период
Сортировка
От Christopher Kings-Lynne
Тема RE: Table/Column Constraints
Дата
Msg-id NEBBIOAJBMEENKACLNPCGEIJCCAA.chriskl@familyhealth.com.au
обсуждение исходный текст
Ответ на Re: Table/Column Constraints  (Philip Warner <pjw@rhyme.com.au>)
Ответы RE: Table/Column Constraints  (Philip Warner <pjw@rhyme.com.au>)
Список pgsql-hackers
> CREATE TABLE example
>  ( example_id  serial
>
>  -- Must be a ZIP or Postal Code
>  , region        varchar(6)
>
>  -- Descriptive text
>  , description varchar(60)
>  );

Actually - this is something I _could_ do.

As the pg_dump is running, it shouldn't be too hard to select the comment
associated with each entity as it is being dumped.  ie.  In the example
above, the comments for each attribute would be retrieved from
pg_description (or whatever) and output as '-- ...' comments.

Then, if the COMMENT ON statements are also still dumped at the bottom, you
get the ability to see comments conveniently in your dump, but with the
ability to still hand-edit them before restoring the dump...

Chris



В списке pgsql-hackers по дате отправления:

Предыдущее
От: "Mitch Vincent"
Дата:
Сообщение: Re: RE: [GENERAL] PHPBuilder article -- Postgres vs MySQL
Следующее
От: Philip Warner
Дата:
Сообщение: RE: Table/Column Constraints