Class PostgreSQLMetadataProcessor
- java.lang.Object
-
- org.teiid.translator.jdbc.JDBCMetadataProcessor
-
- org.teiid.translator.jdbc.postgresql.PostgreSQLMetadataProcessor
-
- All Implemented Interfaces:
MetadataProcessor<Connection>
public class PostgreSQLMetadataProcessor extends JDBCMetadataProcessor
-
-
Field Summary
-
Fields inherited from class org.teiid.translator.jdbc.JDBCMetadataProcessor
useFullSchemaName
-
Fields inherited from interface org.teiid.translator.MetadataProcessor
FQN, SOURCE_PREFIX
-
-
Constructor Summary
Constructors Constructor Description PostgreSQLMetadataProcessor()
-
Method Summary
All Methods Instance Methods Concrete Methods Modifier and Type Method Description protected Column
addColumn(ResultSet columns, Table table, MetadataFactory metadataFactory, int rsColumns)
Add a column to the given table based upon the current row of the columns resultsetprotected Table
addTable(MetadataFactory metadataFactory, String tableCatalog, String tableSchema, String tableName, String remarks, String fullName, ResultSet tables)
protected ResultSet
executeSequenceQuery(Connection conn)
Return a result set with three columns - sequence_catalog, sequence_schema, and sequence_name or null if sequences are not supportedprotected String
getGeographyMetadataTableName()
Return the name of the metadata table or view for geography metadata that conforms to the simple features specification or null if none existsprotected String
getGeometryMetadataTableName()
Return the name of the metadata table or view for geometry metadata that conforms to the simple features specification or null if none existsprotected String
getNativeComponentType(String typeName)
Extract the native component type from the typeName, or return null if that is not possible.protected String
getRuntimeType(int type, String typeName, int precision)
protected String
getSequenceNextSQL(String fullyQualifiedName)
Return the native sql for getting the next value or null if not supported-
Methods inherited from class org.teiid.translator.jdbc.JDBCMetadataProcessor
addTable, getCatalog, getCatalogTerm, getColumnNamePattern, getConnectorMetadata, getExcludeProcedures, getExcludeSequences, getExcludeTables, getFullyQualifiedName, getGeographyMetadata, getGeometryMetadata, getGeospatialMetadata, getIndexInfoForTable, getProcedureNamePattern, getRuntimeType, getSchemaName, getSchemaPattern, getSchemaTerm, getSequenceNamePattern, getSequences, getTableNamePattern, getTableStatistics, getTableTerm, getTableTypes, isAutoCreateUniqueConstraints, isHiddenSchema, isImportApproximateIndexes, isImportForeignKeys, isImportIndexes, isImportKeys, isImportLargeAsLob, isImportProcedures, isImportRowIdAsBinary, isImportSequences, isImportStatistics, isQuoteNameInSource, isUnsignedTypeName, isUseAnyIndexCardinality, isUseCatalogName, isUseFullSchemaName, isUseIntegralTypes, isUseProcedureSpecificName, isUseQualifiedName, isUseTypeInfo, isWidenUnsingedTypes, modifyProcedureNameInSource, process, quoteName, setAutoCreateUniqueConstraints, setCatalog, setColumnNamePattern, setEndQuoteString, setExcludeProcedures, setExcludeSequences, setExcludeTables, setImportApproximateIndexes, setImportForeignKeys, setImportIndexes, setImportKeys, setImportLargeAsLob, setImportProcedures, setImportRowIdAsBinary, setImportSequences, setImportStatistics, setProcedureNamePattern, setQuoteNameInSource, setQuoteString, setSchemaName, setSchemaPattern, setSequenceNamePattern, setStartQuoteString, setTableNamePattern, setTableTypes, setUseAnyIndexCardinality, setUseCatalogName, setUseFullSchemaName, setUseIntegralTypes, setUseProcedureSpecificName, setUseQualifiedName, setUseTypeInfo, setWidenUnsignedTypes, setWidenUnsingedTypes, shouldExclude
-
-
-
-
Method Detail
-
getRuntimeType
protected String getRuntimeType(int type, String typeName, int precision)
- Overrides:
getRuntimeType
in classJDBCMetadataProcessor
-
getNativeComponentType
protected String getNativeComponentType(String typeName)
Description copied from class:JDBCMetadataProcessor
Extract the native component type from the typeName, or return null if that is not possible.- Overrides:
getNativeComponentType
in classJDBCMetadataProcessor
- Returns:
-
addColumn
protected Column addColumn(ResultSet columns, Table table, MetadataFactory metadataFactory, int rsColumns) throws SQLException
Description copied from class:JDBCMetadataProcessor
Add a column to the given table based upon the current row of the columns resultset- Overrides:
addColumn
in classJDBCMetadataProcessor
- Returns:
- the column added
- Throws:
SQLException
-
getGeographyMetadataTableName
protected String getGeographyMetadataTableName()
Description copied from class:JDBCMetadataProcessor
Return the name of the metadata table or view for geography metadata that conforms to the simple features specification or null if none exists- Overrides:
getGeographyMetadataTableName
in classJDBCMetadataProcessor
- Returns:
-
getGeometryMetadataTableName
protected String getGeometryMetadataTableName()
Description copied from class:JDBCMetadataProcessor
Return the name of the metadata table or view for geometry metadata that conforms to the simple features specification or null if none exists- Overrides:
getGeometryMetadataTableName
in classJDBCMetadataProcessor
- Returns:
-
executeSequenceQuery
protected ResultSet executeSequenceQuery(Connection conn) throws SQLException
Description copied from class:JDBCMetadataProcessor
Return a result set with three columns - sequence_catalog, sequence_schema, and sequence_name or null if sequences are not supported- Overrides:
executeSequenceQuery
in classJDBCMetadataProcessor
- Returns:
- Throws:
SQLException
-
getSequenceNextSQL
protected String getSequenceNextSQL(String fullyQualifiedName)
Description copied from class:JDBCMetadataProcessor
Return the native sql for getting the next value or null if not supported- Overrides:
getSequenceNextSQL
in classJDBCMetadataProcessor
- Returns:
-
addTable
protected Table addTable(MetadataFactory metadataFactory, String tableCatalog, String tableSchema, String tableName, String remarks, String fullName, ResultSet tables) throws SQLException
- Overrides:
addTable
in classJDBCMetadataProcessor
- Throws:
SQLException
-
-