in ext/pg_query/pg_query_deparse.c [7033:7208]
static void deparseAlterExtensionContentsStmt(StringInfo str, AlterExtensionContentsStmt *alter_extension_contents_stmt)
{
List *l = NULL;
appendStringInfoString(str, "ALTER EXTENSION ");
deparseColId(str, alter_extension_contents_stmt->extname);
appendStringInfoChar(str, ' ');
if (alter_extension_contents_stmt->action == 1)
appendStringInfoString(str, "ADD ");
else if (alter_extension_contents_stmt->action == -1)
appendStringInfoString(str, "DROP ");
else
Assert(false);
switch (alter_extension_contents_stmt->objtype)
{
case OBJECT_ACCESS_METHOD:
appendStringInfoString(str, "ACCESS METHOD ");
break;
case OBJECT_AGGREGATE:
appendStringInfoString(str, "AGGREGATE ");
break;
case OBJECT_CAST:
appendStringInfoString(str, "CAST ");
break;
case OBJECT_COLLATION:
appendStringInfoString(str, "COLLATION ");
break;
case OBJECT_CONVERSION:
appendStringInfoString(str, "CONVERSION ");
break;
case OBJECT_DOMAIN:
appendStringInfoString(str, "DOMAIN ");
break;
case OBJECT_FUNCTION:
appendStringInfoString(str, "FUNCTION ");
break;
case OBJECT_LANGUAGE:
appendStringInfoString(str, "LANGUAGE ");
break;
case OBJECT_OPERATOR:
appendStringInfoString(str, "OPERATOR ");
break;
case OBJECT_OPCLASS:
appendStringInfoString(str, "OPERATOR CLASS ");
break;
case OBJECT_OPFAMILY:
appendStringInfoString(str, "OPERATOR FAMILY ");
break;
case OBJECT_PROCEDURE:
appendStringInfoString(str, "PROCEDURE ");
break;
case OBJECT_ROUTINE:
appendStringInfoString(str, "ROUTINE ");
break;
case OBJECT_SCHEMA:
appendStringInfoString(str, "SCHEMA ");
break;
case OBJECT_EVENT_TRIGGER:
appendStringInfoString(str, "EVENT TRIGGER ");
break;
case OBJECT_TABLE:
appendStringInfoString(str, "TABLE ");
break;
case OBJECT_TSPARSER:
appendStringInfoString(str, "TEXT SEARCH PARSER ");
break;
case OBJECT_TSDICTIONARY:
appendStringInfoString(str, "TEXT SEARCH DICTIONARY ");
break;
case OBJECT_TSTEMPLATE:
appendStringInfoString(str, "TEXT SEARCH TEMPLATE ");
break;
case OBJECT_TSCONFIGURATION:
appendStringInfoString(str, "TEXT SEARCH CONFIGURATION ");
break;
case OBJECT_SEQUENCE:
appendStringInfoString(str, "SEQUENCE ");
break;
case OBJECT_VIEW:
appendStringInfoString(str, "VIEW ");
break;
case OBJECT_MATVIEW:
appendStringInfoString(str, "MATERIALIZED VIEW ");
break;
case OBJECT_FOREIGN_TABLE:
appendStringInfoString(str, "FOREIGN TABLE ");
break;
case OBJECT_FDW:
appendStringInfoString(str, "FOREIGN DATA WRAPPER ");
break;
case OBJECT_FOREIGN_SERVER:
appendStringInfoString(str, "SERVER ");
break;
case OBJECT_TRANSFORM:
appendStringInfoString(str, "TRANSFORM ");
break;
case OBJECT_TYPE:
appendStringInfoString(str, "TYPE ");
break;
default:
// No other object types are supported here in the parser
Assert(false);
break;
}
switch (alter_extension_contents_stmt->objtype)
{
// any_name
case OBJECT_COLLATION:
case OBJECT_CONVERSION:
case OBJECT_TABLE:
case OBJECT_TSPARSER:
case OBJECT_TSDICTIONARY:
case OBJECT_TSTEMPLATE:
case OBJECT_TSCONFIGURATION:
case OBJECT_SEQUENCE:
case OBJECT_VIEW:
case OBJECT_MATVIEW:
case OBJECT_FOREIGN_TABLE:
deparseAnyName(str, castNode(List, alter_extension_contents_stmt->object));
break;
// name
case OBJECT_ACCESS_METHOD:
case OBJECT_LANGUAGE:
case OBJECT_SCHEMA:
case OBJECT_EVENT_TRIGGER:
case OBJECT_FDW:
case OBJECT_FOREIGN_SERVER:
deparseColId(str, strVal(alter_extension_contents_stmt->object));
break;
case OBJECT_AGGREGATE:
deparseAggregateWithArgtypes(str, castNode(ObjectWithArgs, alter_extension_contents_stmt->object));
break;
case OBJECT_CAST:
l = castNode(List, alter_extension_contents_stmt->object);
Assert(list_length(l) == 2);
appendStringInfoChar(str, '(');
deparseTypeName(str, castNode(TypeName, linitial(l)));
appendStringInfoString(str, " AS ");
deparseTypeName(str, castNode(TypeName, lsecond(l)));
appendStringInfoChar(str, ')');
break;
case OBJECT_DOMAIN:
case OBJECT_TYPE:
deparseTypeName(str, castNode(TypeName, alter_extension_contents_stmt->object));
break;
case OBJECT_FUNCTION:
case OBJECT_PROCEDURE:
case OBJECT_ROUTINE:
deparseFunctionWithArgtypes(str, castNode(ObjectWithArgs, alter_extension_contents_stmt->object));
break;
case OBJECT_OPERATOR:
deparseOperatorWithArgtypes(str, castNode(ObjectWithArgs, alter_extension_contents_stmt->object));
break;
case OBJECT_OPFAMILY:
case OBJECT_OPCLASS:
l = castNode(List, alter_extension_contents_stmt->object);
Assert(list_length(l) == 2);
deparseAnyNameSkipFirst(str, l);
appendStringInfoString(str, " USING ");
deparseColId(str, strVal(linitial(l)));
break;
case OBJECT_TRANSFORM:
l = castNode(List, alter_extension_contents_stmt->object);
appendStringInfoString(str, "FOR ");
deparseTypeName(str, castNode(TypeName, linitial(l)));
appendStringInfoString(str, " LANGUAGE ");
deparseColId(str, strVal(lsecond(l)));
break;
default:
Assert(false);
break;
}
}