Package generalDatabase.postgresql

Class PostgreSQLTypes

java.lang.Object

generalDatabase.SQLTypes

generalDatabase.postgresql.PostgreSQLTypes

public class PostgreSQLTypes
extends SQLTypes

Constructor Summary

Constructors

Constructor	Description
PostgreSQLTypes()

Method Summary

Modifier and Type	Method	Description
String	formatColumnName(String columnName)	Format the column name.
String	formatTableName(String tableName)	Any bespoke formatting of table names
String	typeToString(int sqlType, int length, boolean counter)

Methods inherited from class generalDatabase.SQLTypes

createTableItem, formatColumnName, formatDateTimeMatchString, formatDBDateTimeQueryString, getLocalTimeStamp, getLongValue, getTimeStamp, isAllowBlanks, makeDouble, makeDouble, makeFloat, makeFloat, makeInList, millisFromTimeStamp, setAllowBlanks, stringToLength, stringToType, systemSqlType, typeToString, typeToString

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Details

PostgreSQLTypes

public PostgreSQLTypes()

Method Details

formatColumnName

public String formatColumnName(String columnName)

Description copied from class: SQLTypes

Format the column name. Formats may be slightly different for different DBMS's. e.g. MS Access can put quotes around names. OODB requires them to be all upper case, etc.

Overrides:

formatColumnName in class SQLTypes

Returns:

formatted column name.

typeToString

public String typeToString(int sqlType,
 int length,
 boolean counter)

Overrides:

typeToString in class SQLTypes

formatTableName

public String formatTableName(String tableName)

Description copied from class: SQLTypes

Any bespoke formatting of table names

Overrides:

formatTableName in class SQLTypes

Parameters:

tableName - input table name

Returns:

modified table name (e.g. to lower case)