PostgreSQLDatabaseMeta

java.lang.Object
- org.pentaho.di.core.database.BaseDatabaseMeta
- - org.pentaho.di.core.database.PostgreSQLDatabaseMeta

All Implemented Interfaces:

Cloneable, DatabaseInterface, DatabaseInterfaceExtended

Direct Known Subclasses:

GreenplumDatabaseMeta, RedshiftDatabaseMeta
```
public class PostgreSQLDatabaseMeta
extends BaseDatabaseMeta
implements DatabaseInterface
```
Contains PostgreSQL specific information through static final members

Since:

11-mrt-2005

Author:

Matt

Field Summary
- Fields inherited from class org.pentaho.di.core.database.BaseDatabaseMeta
  ATTRIBUTE_CLUSTER_DBNAME_PREFIX, ATTRIBUTE_CLUSTER_HOSTNAME_PREFIX, ATTRIBUTE_CLUSTER_PASSWORD_PREFIX, ATTRIBUTE_CLUSTER_PORT_PREFIX, ATTRIBUTE_CLUSTER_USERNAME_PREFIX, ATTRIBUTE_FORCE_IDENTIFIERS_TO_LOWERCASE, ATTRIBUTE_FORCE_IDENTIFIERS_TO_UPPERCASE, ATTRIBUTE_INITIAL_POOL_SIZE, ATTRIBUTE_IS_CLUSTERED, ATTRIBUTE_MAXIMUM_POOL_SIZE, ATTRIBUTE_MSSQL_DOUBLE_DECIMAL_SEPARATOR, ATTRIBUTE_POOLING_PARAMETER_PREFIX, ATTRIBUTE_PORT_NUMBER, ATTRIBUTE_PREFERRED_SCHEMA_NAME, ATTRIBUTE_PREFIX_EXTRA_OPTION, ATTRIBUTE_PRESERVE_RESERVED_WORD_CASE, ATTRIBUTE_QUOTE_ALL_FIELDS, ATTRIBUTE_SQL_CONNECT, ATTRIBUTE_SUPPORTS_BOOLEAN_DATA_TYPE, ATTRIBUTE_SUPPORTS_TIMESTAMP_DATA_TYPE, ATTRIBUTE_USE_POOLING, ATTRIBUTE_USE_RESULT_STREAMING, AUTOINCREMENT_SQL_FOR_BATCH_ID, poolingParameters, SELECT_COUNT_STATEMENT, SEQUENCE_FOR_BATCH_ID

Constructor Summary

Constructors
Constructor and Description

PostgreSQLDatabaseMeta()

Constructors
Constructor and Description
`PostgreSQLDatabaseMeta()`

Method Summary

All Methods Instance Methods Concrete Methods
Modifier and Type	Method and Description
`int[]`	`getAccessTypeList()` Get the list of possible access types for a database.
`String`	`getAddColumnStatement(String tablename, ValueMetaInterface v, String tk, boolean use_autoinc, String pk, boolean semicolon)` Generates the SQL statement to add a column to the specified table
`int`	`getDefaultDatabasePort()`
`String`	`getDriverClass()` Obtain the name of the JDBC driver class that we need to use!
`String`	`getDropColumnStatement(String tablename, ValueMetaInterface v, String tk, boolean use_autoinc, String pk, boolean semicolon)` Generates the SQL statement to drop a column from the specified table
`String`	`getExtraOptionIndicator()`
`String`	`getExtraOptionSeparator()`
`String`	`getExtraOptionsHelpText()`
`String`	`getFieldDefinition(ValueMetaInterface v, String tk, String pk, boolean use_autoinc, boolean add_fieldname, boolean add_cr)` Describe a Value as a field in the database.
`String`	`getLimitClause(int nrRows)`
`String`	`getModifyColumnStatement(String tablename, ValueMetaInterface v, String tk, boolean use_autoinc, String pk, boolean semicolon)` Generates the SQL statement to modify a column in the specified table
`String[]`	`getReservedWords()`
`String`	`getSQLColumnExists(String columnname, String tablename)`
`String`	`getSQLCurrentSequenceValue(String sequenceName)` Get the SQL to get the next value of a sequence.
`String`	`getSQLListOfProcedures()`
`String`	`getSQLListOfSequences()`
`String`	`getSQLLockTables(String[] tableNames)`
`String`	`getSQLNextSequenceValue(String sequenceName)` Get the SQL to get the next value of a sequence.
`String`	`getSQLQueryColumnFields(String columnname, String tableName)`
`String`	`getSQLQueryFields(String tableName)` Returns the minimal SQL to launch in order to determine the layout of the resultset for a given database table
`String`	`getSQLSequenceExists(String sequenceName)` Check if a sequence exists.
`String`	`getSQLTableExists(String tablename)`
`String`	`getSQLUnlockTables(String[] tableName)`
`String`	`getURL(String hostname, String port, String databaseName)`
`String[]`	`getUsedLibraries()`
`boolean`	`isDefaultingToUppercase()`
`boolean`	`isFetchSizeSupported()` Checks whether or not the command setFetchSize() is supported by the JDBC driver...
`boolean`	`needsToLockAllTables()`
`String`	`quoteSQLString(String string)` PG needs the extra E in front of the string before it allows you to quote it.
`boolean`	`requiresCastToVariousForIsNull()`
`boolean`	`supportsAutoInc()` Support for the serial field is only fake in PostgreSQL.
`boolean`	`supportsBitmapIndex()`
`boolean`	`supportsErrorHandlingOnBatchUpdates()`
`boolean`	`supportsGetBlob()`
`boolean`	`supportsRepository()`
`boolean`	`supportsSequenceNoMaxValueOption()`
`boolean`	`supportsSequences()`
`boolean`	`supportsSynonyms()`
`boolean`	`useSafePoints()`

Methods inherited from class org.pentaho.di.core.database.BaseDatabaseMeta
addDefaultOptions, addExtraOption, canTest, checkIndexExists, clone, customizeValueFromSQLType, fullExceptionLog, generateColumnAlias, getAccessType, getAttributes, getBackwardsCompatibleSchemaTableCombination, getBackwardsCompatibleTable, getConnectionPoolingProperties, getConnectSQL, getCreateTableStatement, getDatabaseFactoryName, getDatabaseName, getDatabasePortNumberString, getDataTablespace, getDataTablespaceDDL, getDefaultOptions, getDisplayName, getDropTableIfExistsStatement, getEndQuote, getExtraOptions, getExtraOptionValueSeparator, getFunctionAverage, getFunctionCount, getFunctionMaximum, getFunctionMinimum, getFunctionSum, getHostname, getIndexTablespace, getIndexTablespaceDDL, getInitialPoolSize, getMaxColumnsInIndex, getMaximumPoolSize, getMaxTextFieldLength, getMaxVARCHARLength, getName, getNextBatchId, getNextBatchIdUsingAutoIncSQL, getNextBatchIdUsingLockTables, getNextBatchIdUsingSequence, getNotFoundTK, getObjectId, getPartitioningInformation, getPassword, getPluginId, getPluginName, getPreferredSchemaName, getSafeFieldname, getSchemaTableCombination, getSelectCountStatement, getSequenceNoMaxValueOption, getServername, getSQLInsertAutoIncUnknownDimensionRow, getSQLListOfSchemas, getSqlScriptStatements, getSQLValue, getStartQuote, getSynonymTypes, getTablespaceDDL, getTableTypes, getTruncateTableStatement, getUsername, getValueFromResultSet, getViewTypes, getXulOverlayFile, isChanged, isDisplaySizeTwiceThePrecision, isExplorable, isForcingIdentifiersToLowerCase, isForcingIdentifiersToUpperCase, isMySQLVariant, isPartitioned, isQuoteAllFields, isRequiringTransactionsOnQueries, isStreamingResults, isSystemTable, isUsingConnectionPool, isUsingDoubleDecimalAsSchemaTableSeparator, needsPlaceHolder, parseStatements, preserveReservedCase, quoteReservedWords, releaseSavepoint, requiresCreateTablePrimaryKeyAppend, requiresName, setAccessType, setAttributes, setChanged, setConnectionPoolingProperties, setConnectSQL, setDatabaseName, setDatabasePortNumberString, setDataTablespace, setDisplayName, setForcingIdentifiersToLowerCase, setForcingIdentifiersToUpperCase, setHostname, setIndexTablespace, setInitialPoolSize, setMaximumPoolSize, setName, setObjectId, setPartitioned, setPartitioningInformation, setPassword, setPluginId, setPluginName, setPreferredSchemaName, setPreserveReservedCase, setQuoteAllFields, setServername, setStreamingResults, setSupportsBooleanDataType, setSupportsTimestampDataType, setUsername, setUsingConnectionPool, setUsingDoubleDecimalAsSchemaTableSeparator, supportsAutoGeneratedKeys, supportsBatchUpdates, supportsBooleanDataType, supportsCatalogs, supportsEmptyTransactions, supportsErrorHandling, supportsFloatRoundingOnUpdate, supportsNewLinesInSQL, supportsOptionsInURL, supportsPreparedStatementMetadataRetrieval, supportsResultSetMetadataRetrievalOnly, supportsSchemas, supportsSetCharacterStream, supportsSetLong, supportsSetMaxRows, supportsTimestampDataType, supportsTimeStampToDateConversion, supportsTransactions, supportsViews, useSchemaNameForTableList

Methods inherited from class java.lang.Object
equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Methods inherited from interface org.pentaho.di.core.database.DatabaseInterface
addDefaultOptions, addExtraOption, checkIndexExists, clone, customizeValueFromSQLType, generateColumnAlias, getAccessType, getAttributes, getConnectionPoolingProperties, getConnectSQL, getCreateTableStatement, getDatabaseFactoryName, getDatabaseName, getDatabasePortNumberString, getDataTablespace, getDataTablespaceDDL, getDefaultOptions, getDisplayName, getEndQuote, getExtraOptions, getExtraOptionValueSeparator, getFunctionAverage, getFunctionCount, getFunctionMaximum, getFunctionMinimum, getFunctionSum, getHostname, getIndexTablespace, getIndexTablespaceDDL, getInitialPoolSize, getMaxColumnsInIndex, getMaximumPoolSize, getMaxTextFieldLength, getMaxVARCHARLength, getName, getNextBatchId, getNotFoundTK, getObjectId, getPartitioningInformation, getPassword, getPluginId, getPluginName, getPreferredSchemaName, getSafeFieldname, getSchemaTableCombination, getSelectCountStatement, getSequenceNoMaxValueOption, getServername, getSQLInsertAutoIncUnknownDimensionRow, getSQLListOfSchemas, getSqlScriptStatements, getSQLValue, getStartQuote, getSynonymTypes, getTableTypes, getTruncateTableStatement, getUsername, getValueFromResultSet, getViewTypes, getXulOverlayFile, isChanged, isDisplaySizeTwiceThePrecision, isExplorable, isForcingIdentifiersToLowerCase, isForcingIdentifiersToUpperCase, isMySQLVariant, isPartitioned, isQuoteAllFields, isRequiringTransactionsOnQueries, isStreamingResults, isSystemTable, isUsingConnectionPool, isUsingDoubleDecimalAsSchemaTableSeparator, needsPlaceHolder, parseStatements, preserveReservedCase, quoteReservedWords, releaseSavepoint, requiresCreateTablePrimaryKeyAppend, setAccessType, setAttributes, setChanged, setConnectionPoolingProperties, setConnectSQL, setDatabaseName, setDatabasePortNumberString, setDataTablespace, setDisplayName, setForcingIdentifiersToLowerCase, setForcingIdentifiersToUpperCase, setHostname, setIndexTablespace, setInitialPoolSize, setMaximumPoolSize, setName, setObjectId, setPartitioned, setPartitioningInformation, setPassword, setPluginId, setPluginName, setPreferredSchemaName, setPreserveReservedCase, setQuoteAllFields, setServername, setStreamingResults, setSupportsBooleanDataType, setSupportsTimestampDataType, setUsername, setUsingConnectionPool, setUsingDoubleDecimalAsSchemaTableSeparator, supportsAutoGeneratedKeys, supportsBatchUpdates, supportsBooleanDataType, supportsCatalogs, supportsEmptyTransactions, supportsErrorHandling, supportsFloatRoundingOnUpdate, supportsNewLinesInSQL, supportsOptionsInURL, supportsPreparedStatementMetadataRetrieval, supportsResultSetMetadataRetrievalOnly, supportsSchemas, supportsSetCharacterStream, supportsSetLong, supportsSetMaxRows, supportsTimestampDataType, supportsTimeStampToDateConversion, supportsTransactions, supportsViews, useSchemaNameForTableList

- Constructor Detail
  - PostgreSQLDatabaseMeta
```
public PostgreSQLDatabaseMeta()
```
- Method Detail
  - getExtraOptionSeparator
```
public String getExtraOptionSeparator()
```
    Specified by:
    
    getExtraOptionSeparator in interface DatabaseInterface
    
    Overrides:
    
    getExtraOptionSeparator in class BaseDatabaseMeta
    
    Returns:
    
    The extra option separator in database URL for this platform
  - getExtraOptionIndicator
```
public String getExtraOptionIndicator()
```
    Specified by:
    
    getExtraOptionIndicator in interface DatabaseInterface
    
    Overrides:
    
    getExtraOptionIndicator in class BaseDatabaseMeta
    
    Returns:
    
    This indicator separates the normal URL from the options
  - getAccessTypeList
```
public int[] getAccessTypeList()
```
    Description copied from interface: DatabaseInterface
    
    Get the list of possible access types for a database.
    
    Specified by:
    
    getAccessTypeList in interface DatabaseInterface
    
    Specified by:
    
    getAccessTypeList in class BaseDatabaseMeta
    
    Returns:
    
    the list of possible access types for a database.
  - getDefaultDatabasePort
```
public int getDefaultDatabasePort()
```
    Specified by:
    
    getDefaultDatabasePort in interface DatabaseInterface
    
    Overrides:
    
    getDefaultDatabasePort in class BaseDatabaseMeta
    
    Returns:
    
    the default database port number
  - getDriverClass
```
public String getDriverClass()
```
    Description copied from interface: DatabaseInterface
    
    Obtain the name of the JDBC driver class that we need to use!
    
    Specified by:
    
    getDriverClass in interface DatabaseInterface
    
    Returns:
    
    the name of the JDBC driver class for the specific database
  - getURL
```
public String getURL(String hostname,
                     String port,
                     String databaseName)
```
    Specified by:
    
    getURL in interface DatabaseInterface
    
    Parameters:
    
    hostname - the hostname
    
    port - the port as a string
    
    databaseName - the database name
    
    Returns:
    
    the URL to use for connecting to the database.
  - isFetchSizeSupported
```
public boolean isFetchSizeSupported()
```
    Checks whether or not the command setFetchSize() is supported by the JDBC driver...
    
    Specified by:
    
    isFetchSizeSupported in interface DatabaseInterface
    
    Overrides:
    
    isFetchSizeSupported in class BaseDatabaseMeta
    
    Returns:
    
    true is setFetchSize() is supported!
  - supportsBitmapIndex
```
public boolean supportsBitmapIndex()
```
    Specified by:
    
    supportsBitmapIndex in interface DatabaseInterface
    
    Overrides:
    
    supportsBitmapIndex in class BaseDatabaseMeta
    
    Returns:
    
    true if the database supports bitmap indexes
  - supportsSynonyms
```
public boolean supportsSynonyms()
```
    Specified by:
    
    supportsSynonyms in interface DatabaseInterface
    
    Overrides:
    
    supportsSynonyms in class BaseDatabaseMeta
    
    Returns:
    
    true if the database supports synonyms
  - supportsSequences
```
public boolean supportsSequences()
```
    Specified by:
    
    supportsSequences in interface DatabaseInterface
    
    Overrides:
    
    supportsSequences in class BaseDatabaseMeta
    
    Returns:
    
    true if the database supports sequences
  - supportsSequenceNoMaxValueOption
```
public boolean supportsSequenceNoMaxValueOption()
```
    Specified by:
    
    supportsSequenceNoMaxValueOption in interface DatabaseInterface
    
    Overrides:
    
    supportsSequenceNoMaxValueOption in class BaseDatabaseMeta
    
    Returns:
    
    true if the database supports the NOMAXVALUE sequence option. The default is false, AS/400 and DB2 support this.
  - supportsAutoInc
```
public boolean supportsAutoInc()
```
    Support for the serial field is only fake in PostgreSQL. You can't get back the value after the inserts (getGeneratedKeys) through JDBC calls. Therefor it's wiser to use the built-in sequence support directly, not the auto increment features.
    
    Specified by:
    
    supportsAutoInc in interface DatabaseInterface
    
    Overrides:
    
    supportsAutoInc in class BaseDatabaseMeta
    
    Returns:
    
    Whether or not the database can use auto increment type of fields (pk)
  - getLimitClause
```
public String getLimitClause(int nrRows)
```
    Specified by:
    
    getLimitClause in interface DatabaseInterface
    
    Overrides:
    
    getLimitClause in class BaseDatabaseMeta
    
    Parameters:
    
    nrRows - The number of rows to which we want to limit the result of the query.
    
    Returns:
    
    the clause after a select statement to limit the number of rows
  - getSQLQueryFields
```
public String getSQLQueryFields(String tableName)
```
    Description copied from class: BaseDatabaseMeta
    
    Returns the minimal SQL to launch in order to determine the layout of the resultset for a given database table
    
    Specified by:
    
    getSQLQueryFields in interface DatabaseInterface
    
    Overrides:
    
    getSQLQueryFields in class BaseDatabaseMeta
    
    Parameters:
    
    tableName - The name of the table to determine the layout for
    
    Returns:
    
    The SQL to launch.
  - getSQLTableExists
```
public String getSQLTableExists(String tablename)
```
    Specified by:
    
    getSQLTableExists in interface DatabaseInterface
    
    Overrides:
    
    getSQLTableExists in class BaseDatabaseMeta
    
    Parameters:
    
    tablename - The table to verify the existance for
    
    Returns:
    
    The SQL to execute to verify if the given table exists. If an Exception is thrown for this SQL, we don't have the table.
  - getSQLColumnExists
```
public String getSQLColumnExists(String columnname,
                                 String tablename)
```
    Specified by:
    
    getSQLColumnExists in interface DatabaseInterface
    
    Overrides:
    
    getSQLColumnExists in class BaseDatabaseMeta
    
    Parameters:
    
    columnname - The column to verify the existance for
    
    tablename - The table to verify the existance for
    
    Returns:
    
    The SQL to execute to verify if the given table exists. If an Exception is thrown for this SQL, we don't have the column.
  - getSQLQueryColumnFields
```
public String getSQLQueryColumnFields(String columnname,
                                      String tableName)
```
  - needsToLockAllTables
```
public boolean needsToLockAllTables()
```
    Specified by:
    
    needsToLockAllTables in interface DatabaseInterface
    
    Overrides:
    
    needsToLockAllTables in class BaseDatabaseMeta
    
    Returns:
    
    true if the database needs all repository tables to be locked, not just one ref table (R_REPOSITORY_LOG)
  - getSQLListOfSequences
```
public String getSQLListOfSequences()
```
    Specified by:
    
    getSQLListOfSequences in interface DatabaseInterface
    
    Overrides:
    
    getSQLListOfSequences in class BaseDatabaseMeta
    
    Returns:
    
    The SQL on this database to get a list of sequences.
  - getSQLNextSequenceValue
```
public String getSQLNextSequenceValue(String sequenceName)
```
    Get the SQL to get the next value of a sequence. (PostgreSQL version)
    
    Specified by:
    
    getSQLNextSequenceValue in interface DatabaseInterface
    
    Overrides:
    
    getSQLNextSequenceValue in class BaseDatabaseMeta
    
    Parameters:
    
    sequenceName - The sequence name
    
    Returns:
    
    the SQL to get the next value of a sequence.
  - getSQLCurrentSequenceValue
```
public String getSQLCurrentSequenceValue(String sequenceName)
```
    Get the SQL to get the next value of a sequence. (PostgreSQL version)
    
    Specified by:
    
    getSQLCurrentSequenceValue in interface DatabaseInterface
    
    Overrides:
    
    getSQLCurrentSequenceValue in class BaseDatabaseMeta
    
    Parameters:
    
    sequenceName - The sequence name
    
    Returns:
    
    the SQL to get the next value of a sequence.
  - getSQLSequenceExists
```
public String getSQLSequenceExists(String sequenceName)
```
    Check if a sequence exists.
    
    Specified by:
    
    getSQLSequenceExists in interface DatabaseInterface
    
    Overrides:
    
    getSQLSequenceExists in class BaseDatabaseMeta
    
    Parameters:
    
    sequenceName - The sequence to check
    
    Returns:
    
    The SQL to get the name of the sequence back from the databases data dictionary
  - getAddColumnStatement
```
public String getAddColumnStatement(String tablename,
                                    ValueMetaInterface v,
                                    String tk,
                                    boolean use_autoinc,
                                    String pk,
                                    boolean semicolon)
```
    Generates the SQL statement to add a column to the specified table
    
    Specified by:
    
    getAddColumnStatement in interface DatabaseInterface
    
    Parameters:
    
    tablename - The table to add
    
    v - The column defined as a value
    
    tk - the name of the technical key field
    
    use_autoinc - whether or not this field uses auto increment
    
    pk - the name of the primary key field
    
    semicolon - whether or not to add a semi-colon behind the statement.
    
    Returns:
    
    the SQL statement to add a column to the specified table
  - getDropColumnStatement
```
public String getDropColumnStatement(String tablename,
                                     ValueMetaInterface v,
                                     String tk,
                                     boolean use_autoinc,
                                     String pk,
                                     boolean semicolon)
```
    Generates the SQL statement to drop a column from the specified table
    
    Specified by:
    
    getDropColumnStatement in interface DatabaseInterface
    
    Overrides:
    
    getDropColumnStatement in class BaseDatabaseMeta
    
    Parameters:
    
    tablename - The table to add
    
    v - The column defined as a value
    
    tk - the name of the technical key field
    
    use_autoinc - whether or not this field uses auto increment
    
    pk - the name of the primary key field
    
    semicolon - whether or not to add a semi-colon behind the statement.
    
    Returns:
    
    the SQL statement to drop a column from the specified table
  - getModifyColumnStatement
```
public String getModifyColumnStatement(String tablename,
                                       ValueMetaInterface v,
                                       String tk,
                                       boolean use_autoinc,
                                       String pk,
                                       boolean semicolon)
```
    Generates the SQL statement to modify a column in the specified table
    
    Specified by:
    
    getModifyColumnStatement in interface DatabaseInterface
    
    Parameters:
    
    tablename - The table to add
    
    v - The column defined as a value
    
    tk - the name of the technical key field
    
    use_autoinc - whether or not this field uses auto increment
    
    pk - the name of the primary key field
    
    semicolon - whether or not to add a semi-colon behind the statement.
    
    Returns:
    
    the SQL statement to modify a column in the specified table
  - getFieldDefinition
```
public String getFieldDefinition(ValueMetaInterface v,
                                 String tk,
                                 String pk,
                                 boolean use_autoinc,
                                 boolean add_fieldname,
                                 boolean add_cr)
```
    Description copied from interface: DatabaseInterface
    
    Describe a Value as a field in the database.
    
    Specified by:
    
    getFieldDefinition in interface DatabaseInterface
    
    Parameters:
    
    v - The value to describe
    
    tk - The field that's going to be the technical key
    
    pk - The field that's going to be the primary key
    
    use_autoinc - Use autoincrement or not
    
    add_fieldname - Add the fieldname to the definition or not
    
    add_cr - Add a cariage return at the end of the definition or not.
    
    Returns:
    
    a value described as a field in this database.
  - getSQLListOfProcedures
```
public String getSQLListOfProcedures()
```
    Specified by:
    
    getSQLListOfProcedures in interface DatabaseInterface
    
    Overrides:
    
    getSQLListOfProcedures in class BaseDatabaseMeta
    
    Returns:
    
    The SQL on this database to get a list of stored procedures.
  - getReservedWords
```
public String[] getReservedWords()
```
    Specified by:
    
    getReservedWords in interface DatabaseInterface
    
    Overrides:
    
    getReservedWords in class BaseDatabaseMeta
    
    Returns:
    
    an array of reserved words for the database type...
  - supportsRepository
```
public boolean supportsRepository()
```
    Specified by:
    
    supportsRepository in interface DatabaseInterface
    
    Overrides:
    
    supportsRepository in class BaseDatabaseMeta
    
    Returns:
    
    true if Kettle can create a repository on this type of database.
  - getSQLLockTables
```
public String getSQLLockTables(String[] tableNames)
```
    Specified by:
    
    getSQLLockTables in interface DatabaseInterface
    
    Overrides:
    
    getSQLLockTables in class BaseDatabaseMeta
    
    Parameters:
    
    tableNames - The names of the tables to lock
    
    Returns:
    
    The SQL commands to lock database tables for write purposes.
  - getSQLUnlockTables
```
public String getSQLUnlockTables(String[] tableName)
```
    Specified by:
    
    getSQLUnlockTables in interface DatabaseInterface
    
    Overrides:
    
    getSQLUnlockTables in class BaseDatabaseMeta
    
    Parameters:
    
    tableName - The name of the table to unlock
    
    Returns:
    
    The SQL command to unlock a database table.
  - isDefaultingToUppercase
```
public boolean isDefaultingToUppercase()
```
    Specified by:
    
    isDefaultingToUppercase in interface DatabaseInterface
    
    Overrides:
    
    isDefaultingToUppercase in class BaseDatabaseMeta
    
    Returns:
    
    true if the database defaults to naming tables and fields in uppercase. True for most databases except for stubborn stuff like PostgreSQL ;-)
  - getExtraOptionsHelpText
```
public String getExtraOptionsHelpText()
```
    Specified by:
    
    getExtraOptionsHelpText in interface DatabaseInterface
    
    Overrides:
    
    getExtraOptionsHelpText in class BaseDatabaseMeta
    
    Returns:
    
    extra help text on the supported options on the selected database platform.
  - getUsedLibraries
```
public String[] getUsedLibraries()
```
    Specified by:
    
    getUsedLibraries in interface DatabaseInterface
    
    Returns:
    
    the required libraries (in lib) for this database connection.
  - supportsErrorHandlingOnBatchUpdates
```
public boolean supportsErrorHandlingOnBatchUpdates()
```
    Specified by:
    
    supportsErrorHandlingOnBatchUpdates in interface DatabaseInterface
    
    Overrides:
    
    supportsErrorHandlingOnBatchUpdates in class BaseDatabaseMeta
    
    Returns:
    
    true if the database supports error handling (recovery of failure) while doing batch updates.
  - quoteSQLString
```
public String quoteSQLString(String string)
```
    PG needs the extra E in front of the string before it allows you to quote it. Imagine that.
    
    Specified by:
    
    quoteSQLString in interface DatabaseInterface
    
    Overrides:
    
    quoteSQLString in class BaseDatabaseMeta
    
    Parameters:
    
    string -
    
    Returns:
    
    A string that is properly quoted for use in a SQL statement (insert, update, delete, etc)
  - requiresCastToVariousForIsNull
```
public boolean requiresCastToVariousForIsNull()
```
    Specified by:
    
    requiresCastToVariousForIsNull in interface DatabaseInterface
    
    Overrides:
    
    requiresCastToVariousForIsNull in class BaseDatabaseMeta
    
    Returns:
    
    true if the database requires you to cast a parameter to varchar before comparing to null. Only required for DB2 and Vertica
  - supportsGetBlob
```
public boolean supportsGetBlob()
```
    Specified by:
    
    supportsGetBlob in interface DatabaseInterface
    
    Overrides:
    
    supportsGetBlob in class BaseDatabaseMeta
    
    Returns:
    
    true if the database JDBC driver supports getBlob on the resultset. If not we must use getBytes() to get the data.
  - useSafePoints
```
public boolean useSafePoints()
```
    Specified by:
    
    useSafePoints in interface DatabaseInterface
    
    Overrides:
    
    useSafePoints in class BaseDatabaseMeta
    
    Returns:
    
    true if the database supports the use of safe-points and if it is appropriate to ever use it (default to false)

Class PostgreSQLDatabaseMeta

Field Summary

Fields inherited from class org.pentaho.di.core.database.BaseDatabaseMeta

Constructor Summary

Method Summary

Methods inherited from class org.pentaho.di.core.database.BaseDatabaseMeta

Methods inherited from class java.lang.Object

Methods inherited from interface org.pentaho.di.core.database.DatabaseInterface

Constructor Detail

PostgreSQLDatabaseMeta

Method Detail

getExtraOptionSeparator

getExtraOptionIndicator

getAccessTypeList

getDefaultDatabasePort

getDriverClass

getURL

isFetchSizeSupported

supportsBitmapIndex

supportsSynonyms

supportsSequences

supportsSequenceNoMaxValueOption

supportsAutoInc

getLimitClause

getSQLQueryFields

getSQLTableExists

getSQLColumnExists

getSQLQueryColumnFields

needsToLockAllTables

getSQLListOfSequences

getSQLNextSequenceValue

getSQLCurrentSequenceValue

getSQLSequenceExists

getAddColumnStatement

getDropColumnStatement

getModifyColumnStatement

getFieldDefinition

getSQLListOfProcedures

getReservedWords

supportsRepository

getSQLLockTables

getSQLUnlockTables

isDefaultingToUppercase

getExtraOptionsHelpText

getUsedLibraries

supportsErrorHandlingOnBatchUpdates

quoteSQLString

requiresCastToVariousForIsNull

supportsGetBlob

useSafePoints