Package org.pgcodekeeper.core.database.pg.schema

Interface PgForeignOptionContainer

All Superinterfaces:

IOptionContainer, IStatement

All Known Implementing Classes:

GpExternalTable, PgAbstractForeignTable, PgForeignDataWrapper, PgPartitionForeignTable, PgServer, PgSimpleForeignTable, PgUserMapping

public interface PgForeignOptionContainer
extends IOptionContainer

Interface for PostgreSQL objects that support foreign table options. Provides common functionality for handling OPTIONS clause used in foreign tables, foreign data wrappers, and servers.

Field Summary

Fields

Modifier and Type	Field	Description
static final String	ALTER_FOREIGN_OPTION
static final String	DELIM

Method Summary

Modifier and Type	Method	Description
default void	appendOptions(StringBuilder sb)	Appends SQL OPTIONS clause to StringBuilder.
default void	compareOptions(IOptionContainer newContainer, SQLScript script)	Compares options between this container and a new container, generating SQL to update differences.
String	getAlterHeader()	Returns the ALTER statement header for this object.

Methods inherited from interface org.pgcodekeeper.core.database.api.schema.IOptionContainer

addOption, getOptions

Methods inherited from interface org.pgcodekeeper.core.database.api.schema.IStatement

addDependency, appendAlterSQL, appendOwnerSQL, canDrop, canDropBeforeCreate, clearPrivileges, compare, deepCopy, formatSql, getAuthor, getBareName, getChildren, getComment, getCreationSQL, getDatabase, getDependencies, getDescendants, getDropSQL, getLibName, getLocation, getName, getOwner, getParent, getPrivileges, getQualifiedName, getQuotedName, getQuoter, getRenameCommand, getSeparator, getSQL, getStatementType, getTwin, getTypeName, hasChildren, isLib, isOwned, quote, setComment, setLibName, setLocation, setOwner, shallowCopy, toObjectReference

Field Details

ALTER_FOREIGN_OPTION

static final String ALTER_FOREIGN_OPTION

See Also:

• Constant Field Values

DELIM

static final String DELIM

See Also:

• Constant Field Values

Method Details

getAlterHeader

String getAlterHeader()

Returns the ALTER statement header for this object.

Returns:

ALTER statement prefix (e.g., "ALTER FOREIGN TABLE table_name")

appendOptions

default void appendOptions(StringBuilder sb)

Appends SQL OPTIONS clause to StringBuilder.

Parameters:

sb - the StringBuilder to append to

compareOptions

default void compareOptions(IOptionContainer newContainer,
 SQLScript script)

Description copied from interface: IOptionContainer

Compares options between this container and a new container, generating SQL to update differences.

Specified by:

compareOptions in interface IOptionContainer

Parameters:

newContainer - the new container to compare against

script - the script to append changes to