Revision 13480
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/schemas/util.sql | ||
|---|---|---|
| 3771 | 3771 |
CREATE FUNCTION show_set_comment(table_ regclass) RETURNS text |
| 3772 | 3772 |
LANGUAGE sql STABLE |
| 3773 | 3773 |
AS $_$ |
| 3774 |
SELECT util.mk_set_comment($1, COALESCE(util.comment($1), ''/*= no comment*/))
|
|
| 3774 |
SELECT util.mk_set_comment($1, util.comment($1))
|
|
| 3775 | 3775 |
$_$; |
| 3776 | 3776 |
|
| 3777 | 3777 |
|
Also available in: Unified diff
fix: schemas/util.sql: show_set_comment(): don't display a COMMENT ON statement if no comment, because this will be appended to table defs, etc. and would create clutter