public class PostgreSQLDB extends BaseDB
ALTER_COLUMN_NAME, ALTER_COLUMN_TYPE, ALTER_TABLE_NAME, columnTypePattern, CREATE_TABLE, DROP_INDEX, DROP_PRIMARY_KEY, RENAME_TABLE_TEMPLATE, REWORD_TEMPLATE, SQL_VARCHAR_TYPES, TEMPLATE| Constructor and Description |
|---|
PostgreSQLDB(int majorVersion,
int minorVersion) |
| Modifier and Type | Method and Description |
|---|---|
String |
buildSQL(String template) |
static String |
getCreateRulesSQL(String tableName,
String columnName) |
List<com.liferay.portal.kernel.dao.db.Index> |
getIndexes(Connection connection) |
String |
getNewUuidFunctionName() |
String |
getPopulateSQL(String databaseName,
String sqlContent) |
String |
getRecreateSQL(String databaseName) |
protected int[] |
getSQLTypes() |
protected int[] |
getSQLVarcharSizes() |
protected String[] |
getTemplate() |
protected boolean |
isSupportsDuplicatedIndexName() |
boolean |
isSupportsNewUuidFunction() |
boolean |
isSupportsQueryingAfterException() |
protected String |
reword(String data) |
addIndexes, addPrimaryKey, alterColumnName, alterColumnType, alterTableAddColumn, alterTableDropColumn, buildColumnNameTokens, buildColumnTypeTokens, buildTableNameTokens, copyTableRows, copyTableStructure, dropIndexes, dropIndexes, getCopyTableStructureSQL, getDBType, getIndexes, getIndexResultSet, getMajorVersion, getMinorVersion, getPrimaryKeyColumnNames, getSQLType, getSQLVarcharSize, getTemplateBlob, getTemplateFalse, getTemplateTrue, getVersionString, isSupportsAlterColumnName, isSupportsAlterColumnType, isSupportsInlineDistinct, isSupportsScrollableResults, isSupportsStringCaseSensitiveQuery, isSupportsUpdateWithInnerJoin, limitColumnLength, process, removePrimaryKey, replaceTemplate, runSQL, runSQL, runSQL, runSQL, runSQLTemplateString, runSQLTemplateString, setSupportsStringCaseSensitiveQuery, updateIndexespublic static String getCreateRulesSQL(String tableName,
String columnName)
public String buildSQL(String template)
throws IOException
public List<com.liferay.portal.kernel.dao.db.Index> getIndexes(Connection connection)
throws SQLException
getIndexes in interface com.liferay.portal.kernel.dao.db.DBgetIndexes in class BaseDBSQLExceptionpublic String getNewUuidFunctionName()
public String getPopulateSQL(String databaseName,
String sqlContent)
public String getRecreateSQL(String databaseName)
public boolean isSupportsNewUuidFunction()
public boolean isSupportsQueryingAfterException()
isSupportsQueryingAfterException in interface com.liferay.portal.kernel.dao.db.DBisSupportsQueryingAfterException in class BaseDBprotected int[] getSQLTypes()
getSQLTypes in class BaseDBprotected int[] getSQLVarcharSizes()
getSQLVarcharSizes in class BaseDBprotected String[] getTemplate()
getTemplate in class BaseDBprotected boolean isSupportsDuplicatedIndexName()
isSupportsDuplicatedIndexName in class BaseDB