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 |
getPopulateSQL(String databaseName,
String sqlContent) |
String |
getRecreateSQL(String databaseName) |
protected int[] |
getSQLTypes() |
protected int[] |
getSQLVarcharSizes() |
protected String[] |
getTemplate() |
boolean |
isSupportsQueryingAfterException() |
protected String |
reword(String data) |
addIndexes, addPrimaryKey, alterColumnName, alterColumnType, alterTableAddColumn, alterTableDropColumn, buildColumnNameTokens, buildColumnTypeTokens, buildTableNameTokens, dropIndexes, dropIndexes, 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 getPopulateSQL(String databaseName,
String sqlContent)
public String getRecreateSQL(String databaseName)
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 BaseDB