RE: Table/Column Constraints
От
Christopher Kings-Lynne
Тема
RE: Table/Column Constraints
Дата
Msg-id
NEBBIOAJBMEENKACLNPCGEIJCCAA.chriskl@familyhealth.com.au
Ответ на
Re: Table/Column Constraints (Philip Warner)
Список
Дерево обсуждения
Table/Column Constraints "Christopher Kings-Lynne" <chriskl@familyhealth.com.au>
Re: Table/Column Constraints Tom Lane <tgl@sss.pgh.pa.us>
RE: Table/Column Constraints "Christopher Kings-Lynne" <chriskl@familyhealth.com.au>
> 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
Дата: