in ext/pg_query/pg_query_deparse.c [8356:8599]
static void deparseCommentStmt(StringInfo str, CommentStmt *comment_stmt)
{
ListCell *lc;
List *l;
appendStringInfoString(str, "COMMENT ON ");
switch (comment_stmt->objtype)
{
case OBJECT_COLUMN:
appendStringInfoString(str, "COLUMN ");
break;
case OBJECT_INDEX:
appendStringInfoString(str, "INDEX ");
break;
case OBJECT_SEQUENCE:
appendStringInfoString(str, "SEQUENCE ");
break;
case OBJECT_STATISTIC_EXT:
appendStringInfoString(str, "STATISTICS ");
break;
case OBJECT_TABLE:
appendStringInfoString(str, "TABLE ");
break;
case OBJECT_VIEW:
appendStringInfoString(str, "VIEW ");
break;
case OBJECT_MATVIEW:
appendStringInfoString(str, "MATERIALIZED VIEW ");
break;
case OBJECT_COLLATION:
appendStringInfoString(str, "COLLATION ");
break;
case OBJECT_CONVERSION:
appendStringInfoString(str, "CONVERSION ");
break;
case OBJECT_FOREIGN_TABLE:
appendStringInfoString(str, "FOREIGN TABLE ");
break;
case OBJECT_TSCONFIGURATION:
appendStringInfoString(str, "TEXT SEARCH CONFIGURATION ");
break;
case OBJECT_TSDICTIONARY:
appendStringInfoString(str, "TEXT SEARCH DICTIONARY ");
break;
case OBJECT_TSPARSER:
appendStringInfoString(str, "TEXT SEARCH PARSER ");
break;
case OBJECT_TSTEMPLATE:
appendStringInfoString(str, "TEXT SEARCH TEMPLATE ");
break;
case OBJECT_ACCESS_METHOD:
appendStringInfoString(str, "ACCESS METHOD ");
break;
case OBJECT_DATABASE:
appendStringInfoString(str, "DATABASE ");
break;
case OBJECT_EVENT_TRIGGER:
appendStringInfoString(str, "EVENT TRIGGER ");
break;
case OBJECT_EXTENSION:
appendStringInfoString(str, "EXTENSION ");
break;
case OBJECT_FDW:
appendStringInfoString(str, "FOREIGN DATA WRAPPER ");
break;
case OBJECT_LANGUAGE:
appendStringInfoString(str, "LANGUAGE ");
break;
case OBJECT_PUBLICATION:
appendStringInfoString(str, "PUBLICATION ");
break;
case OBJECT_ROLE:
appendStringInfoString(str, "ROLE ");
break;
case OBJECT_SCHEMA:
appendStringInfoString(str, "SCHEMA ");
break;
case OBJECT_FOREIGN_SERVER:
appendStringInfoString(str, "SERVER ");
break;
case OBJECT_SUBSCRIPTION:
appendStringInfoString(str, "SUBSCRIPTION ");
break;
case OBJECT_TABLESPACE:
appendStringInfoString(str, "TABLESPACE ");
break;
case OBJECT_TYPE:
appendStringInfoString(str, "TYPE ");
break;
case OBJECT_DOMAIN:
appendStringInfoString(str, "DOMAIN ");
break;
case OBJECT_AGGREGATE:
appendStringInfoString(str, "AGGREGATE ");
break;
case OBJECT_FUNCTION:
appendStringInfoString(str, "FUNCTION ");
break;
case OBJECT_OPERATOR:
appendStringInfoString(str, "OPERATOR ");
break;
case OBJECT_TABCONSTRAINT:
appendStringInfoString(str, "CONSTRAINT ");
break;
case OBJECT_DOMCONSTRAINT:
appendStringInfoString(str, "CONSTRAINT ");
break;
case OBJECT_POLICY:
appendStringInfoString(str, "POLICY ");
break;
case OBJECT_PROCEDURE:
appendStringInfoString(str, "PROCEDURE ");
break;
case OBJECT_ROUTINE:
appendStringInfoString(str, "ROUTINE ");
break;
case OBJECT_RULE:
appendStringInfoString(str, "RULE ");
break;
case OBJECT_TRANSFORM:
appendStringInfoString(str, "TRANSFORM ");
break;
case OBJECT_TRIGGER:
appendStringInfoString(str, "TRIGGER ");
break;
case OBJECT_OPCLASS:
appendStringInfoString(str, "OPERATOR CLASS ");
break;
case OBJECT_OPFAMILY:
appendStringInfoString(str, "OPERATOR FAMILY ");
break;
case OBJECT_LARGEOBJECT:
appendStringInfoString(str, "LARGE OBJECT ");
break;
case OBJECT_CAST:
appendStringInfoString(str, "CAST ");
break;
default:
// No other cases are supported in the parser
Assert(false);
break;
}
switch (comment_stmt->objtype)
{
case OBJECT_COLUMN:
case OBJECT_INDEX:
case OBJECT_SEQUENCE:
case OBJECT_STATISTIC_EXT:
case OBJECT_TABLE:
case OBJECT_VIEW:
case OBJECT_MATVIEW:
case OBJECT_COLLATION:
case OBJECT_CONVERSION:
case OBJECT_FOREIGN_TABLE:
case OBJECT_TSCONFIGURATION:
case OBJECT_TSDICTIONARY:
case OBJECT_TSPARSER:
case OBJECT_TSTEMPLATE:
deparseAnyName(str, castNode(List, comment_stmt->object));
break;
case OBJECT_ACCESS_METHOD:
case OBJECT_DATABASE:
case OBJECT_EVENT_TRIGGER:
case OBJECT_EXTENSION:
case OBJECT_FDW:
case OBJECT_LANGUAGE:
case OBJECT_PUBLICATION:
case OBJECT_ROLE:
case OBJECT_SCHEMA:
case OBJECT_FOREIGN_SERVER:
case OBJECT_SUBSCRIPTION:
case OBJECT_TABLESPACE:
appendStringInfoString(str, quote_identifier(strVal(comment_stmt->object)));
break;
case OBJECT_TYPE:
case OBJECT_DOMAIN:
deparseTypeName(str, castNode(TypeName, comment_stmt->object));
break;
case OBJECT_AGGREGATE:
deparseAggregateWithArgtypes(str, castNode(ObjectWithArgs, comment_stmt->object));
break;
case OBJECT_FUNCTION:
case OBJECT_PROCEDURE:
case OBJECT_ROUTINE:
deparseFunctionWithArgtypes(str, castNode(ObjectWithArgs, comment_stmt->object));
break;
case OBJECT_OPERATOR:
deparseOperatorWithArgtypes(str, castNode(ObjectWithArgs, comment_stmt->object));
break;
case OBJECT_TABCONSTRAINT:
case OBJECT_POLICY:
case OBJECT_RULE:
case OBJECT_TRIGGER:
l = castNode(List, comment_stmt->object);
appendStringInfoString(str, quote_identifier(strVal(llast(l))));
appendStringInfoString(str, " ON ");
deparseAnyNameSkipLast(str, l);
break;
case OBJECT_DOMCONSTRAINT:
l = castNode(List, comment_stmt->object);
appendStringInfoString(str, quote_identifier(strVal(llast(l))));
appendStringInfoString(str, " ON DOMAIN ");
deparseTypeName(str, linitial(l));
break;
case OBJECT_TRANSFORM:
l = castNode(List, comment_stmt->object);
appendStringInfoString(str, "FOR ");
deparseTypeName(str, castNode(TypeName, linitial(l)));
appendStringInfoString(str, " LANGUAGE ");
appendStringInfoString(str, quote_identifier(strVal(lsecond(l))));
break;
case OBJECT_OPCLASS:
case OBJECT_OPFAMILY:
l = castNode(List, comment_stmt->object);
deparseAnyNameSkipFirst(str, l);
appendStringInfoString(str, " USING ");
appendStringInfoString(str, quote_identifier(strVal(linitial(l))));
break;
case OBJECT_LARGEOBJECT:
deparseValue(str, (Value *) comment_stmt->object, DEPARSE_NODE_CONTEXT_NONE);
break;
case OBJECT_CAST:
l = castNode(List, comment_stmt->object);
appendStringInfoChar(str, '(');
deparseTypeName(str, castNode(TypeName, linitial(l)));
appendStringInfoString(str, " AS ");
deparseTypeName(str, castNode(TypeName, lsecond(l)));
appendStringInfoChar(str, ')');
break;
default:
// No other cases are supported in the parser
Assert(false);
break;
}
appendStringInfoString(str, " IS ");
if (comment_stmt->comment != NULL)
deparseStringLiteral(str, comment_stmt->comment);
else
appendStringInfoString(str, "NULL");
}