Adding comments for system table/column names
От | Bruce Momjian |
---|---|
Тема | Adding comments for system table/column names |
Дата | |
Msg-id | 20121012172921.GA31031@momjian.us обсуждение исходный текст |
Ответы |
Re: Adding comments for system table/column names
Re: Adding comments for system table/column names |
Список | pgsql-hackers |
There was a thread in January of 2012 where we discussed the idea of pulling system table/column name descriptions from the SGML docs and creating SQL comments for them: http://archives.postgresql.org/pgsql-hackers/2012-01/msg00837.php Magnus didn't seem to like the idea: http://archives.postgresql.org/pgsql-hackers/2012-01/msg00848.php Well, I'd expect some of those columns to get (at least over time)significantly more detailed information than they havenow. Certainlymore than you'd put in comments in the catalogs. And having some sortof combination there seems to overcomplicatethings... I think the idea of having the short descriptions in SQL and longer ones in SGML is not maintainable. One idea would be to clip the SQL description to be no longer than a specified number of characters, with proper word break detection. Here is how psql displays column and table comments: test=> create table test(x int);CREATE TABLEtest=> comment on column test.x IS 'wow';COMMENTtest=> \d+ test Table "public.test" Column | Type | Modifiers | Storage | Stats target | Description--------+---------+-----------+---------+--------------+-------------x | integer | | plain | | wowHas OIDs: no test=> comment on table test is 'yikes';COMMENTtest=> \d+ List of relations Schema | Name | Type | Owner | Size | Description--------+------+-------+----------+---------+------------- public | test | table | postgres| 0 bytes | yikes(1 row) Should I continue working on this patch? -- Bruce Momjian <bruce@momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com + It's impossible for everything to be true. +
В списке pgsql-hackers по дате отправления: