DatabaseUtils.props

# Database settings for PostgreSQL 7.4
#
# General information on database access can be found here:
# http://weka.wikispaces.com/Databases
#
# url:     http://www.postgresql.org/
# jdbc:    http://jdbc.postgresql.org/
# author:  Fracpete (fracpete at waikato dot ac dot nz)
# version: $Revision: 11885 $

# JDBC driver (comma-separated list)
jdbcDriver=org.postgresql.Driver

# database URL
jdbcURL=jdbc:postgresql://server_name:5432/database_name

# specific data types
# string, getString() = 0;    --> nominal
char=0
string=0
# boolean, getBoolean() = 1;  --> nominal
boolean=1
bool=1
char1=0
# double, getDouble() = 2;    --> numeric
# byte, getByte() = 3;        --> numeric
# short, getByte()= 4;        --> numeric
# int, getInteger() = 5;      --> numeric
# long, getLong() = 6;        --> numeric
# float, getFloat() = 7;      --> numeric
# date, getDate() = 8;        --> date
# text, getString() = 9;      --> string
# time, getTime() = 10;       --> date
# timestamp, getTime() = 11;  --> date

# PostgreSQL data types to Java classes information can be found at:
# http://www.postgresql.org/message-id/AANLkTinsk4rwT7v-751bwQkgTN1rkA=8uE-jk69nape-@mail.gmail.com
varchar=0
text=0
float4=7
float8=2
int4=5
oid=5
timestamp=8
date=8

int2=5
int8=2
numeric=2
bpchar=0
#bpchar=9

# other options
CREATE_DOUBLE=float8
CREATE_STRING=text
CREATE_INT=int
CREATE_DATE=TIMESTAMP
DateFormat=yyyy-MM-dd HH:mm:ss
checkUpperCaseNames=false
checkLowerCaseNames=true
checkForTable=true

# All the reserved keywords for this database
# Based on the keywords listed at the following URL (2009-04-13):
# http://www.postgresql.org/docs/7.4/static/sql-keywords-appendix.html
Keywords=\
  ABORT,\
  ABS,\
  ABSOLUTE,\
  ACCESS,\
  ACTION,\
  ADA,\
  ADD,\
  ADMIN,\
  AFTER,\
  AGGREGATE,\
  ALIAS,\
  ALL,\
  ALLOCATE,\
  ALTER,\
  ANALYSE,\
  ANALYZE,\
  AND,\
  ANY,\
  ARE,\
  ARRAY,\
  AS,\
  ASC,\
  ASENSITIVE,\
  ASSERTION,\
  ASSIGNMENT,\
  ASYMMETRIC,\
  AT,\
  ATOMIC,\
  AUTHORIZATION,\
  AVG,\
  BACKWARD,\
  BEFORE,\
  BEGIN,\
  BETWEEN,\
  BIGINT,\
  BINARY,\
  BIT,\
  BITVAR,\
  BIT_LENGTH,\
  BLOB,\
  BOOLEAN,\
  BOTH,\
  BREADTH,\
  BY,\
  C,\
  CACHE,\
  CALL,\
  CALLED,\
  CARDINALITY,\
  CASCADE,\
  CASCADED,\
  CASE,\
  CAST,\
  CATALOG,\
  CATALOG_NAME,\
  CHAIN,\
  CHAR,\
  CHARACTER,\
  CHARACTERISTICS,\
  CHARACTER_LENGTH,\
  CHARACTER_SET_CATALOG,\
  CHARACTER_SET_NAME,\
  CHARACTER_SET_SCHEMA,\
  CHAR_LENGTH,\
  CHECK,\
  CHECKED,\
  CHECKPOINT,\
  CLASS,\
  CLASS_ORIGIN,\
  CLOB,\
  CLOSE,\
  CLUSTER,\
  COALESCE,\
  COBOL,\
  COLLATE,\
  COLLATION,\
  COLLATION_CATALOG,\
  COLLATION_NAME,\
  COLLATION_SCHEMA,\
  COLUMN,\
  COLUMN_NAME,\
  COMMAND_FUNCTION,\
  COMMAND_FUNCTION_CODE,\
  COMMENT,\
  COMMIT,\
  COMMITTED,\
  COMPLETION,\
  CONDITION_NUMBER,\
  CONNECT,\
  CONNECTION,\
  CONNECTION_NAME,\
  CONSTRAINT,\
  CONSTRAINTS,\
  CONSTRAINT_CATALOG,\
  CONSTRAINT_NAME,\
  CONSTRAINT_SCHEMA,\
  CONSTRUCTOR,\
  CONTAINS,\
  CONTINUE,\
  CONVERSION,\
  CONVERT,\
  COPY,\
  CORRESPONDING,\
  COUNT,\
  CREATE,\
  CREATEDB,\
  CREATEUSER,\
  CROSS,\
  CUBE,\
  CURRENT,\
  CURRENT_DATE,\
  CURRENT_PATH,\
  CURRENT_ROLE,\
  CURRENT_TIME,\
  CURRENT_TIMESTAMP,\
  CURRENT_USER,\
  CURSOR,\
  CURSOR_NAME,\
  CYCLE,\
  DATA,\
  DATABASE,\
  DATE,\
  DATETIME_INTERVAL_CODE,\
  DATETIME_INTERVAL_PRECISION,\
  DAY,\
  DEALLOCATE,\
  DEC,\
  DECIMAL,\
  DECLARE,\
  DEFAULT,\
  DEFAULTS,\
  DEFERRABLE,\
  DEFERRED,\
  DEFINED,\
  DEFINER,\
  DELETE,\
  DELIMITER,\
  DELIMITERS,\
  DEPTH,\
  DEREF,\
  DESC,\
  DESCRIBE,\
  DESCRIPTOR,\
  DESTROY,\
  DESTRUCTOR,\
  DETERMINISTIC,\
  DIAGNOSTICS,\
  DICTIONARY,\
  DISCONNECT,\
  DISPATCH,\
  DISTINCT,\
  DO,\
  DOMAIN,\
  DOUBLE,\
  DROP,\
  DYNAMIC,\
  DYNAMIC_FUNCTION,\
  DYNAMIC_FUNCTION_CODE,\
  EACH,\
  ELSE,\
  ENCODING,\
  ENCRYPTED,\
  END,\
  END-EXEC,\
  EQUALS,\
  ESCAPE,\
  EVERY,\
  EXCEPT,\
  EXCEPTION,\
  EXCLUDING,\
  EXCLUSIVE,\
  EXEC,\
  EXECUTE,\
  EXISTING,\
  EXISTS,\
  EXPLAIN,\
  EXTERNAL,\
  EXTRACT,\
  FALSE,\
  FETCH,\
  FINAL,\
  FIRST,\
  FLOAT,\
  FOR,\
  FORCE,\
  FOREIGN,\
  FORTRAN,\
  FORWARD,\
  FOUND,\
  FREE,\
  FREEZE,\
  FROM,\
  FULL,\
  FUNCTION,\
  G,\
  GENERAL,\
  GENERATED,\
  GET,\
  GLOBAL,\
  GO,\
  GOTO,\
  GRANT,\
  GRANTED,\
  GROUP,\
  GROUPING,\
  HANDLER,\
  HAVING,\
  HIERARCHY,\
  HOLD,\
  HOST,\
  HOUR,\
  IDENTITY,\
  IGNORE,\
  ILIKE,\
  IMMEDIATE,\
  IMMUTABLE,\
  IMPLEMENTATION,\
  IMPLICIT,\
  IN,\
  INCLUDING,\
  INCREMENT,\
  INDEX,\
  INDICATOR,\
  INFIX,\
  INHERITS,\
  INITIALIZE,\
  INITIALLY,\
  INNER,\
  INOUT,\
  INPUT,\
  INSENSITIVE,\
  INSERT,\
  INSTANCE,\
  INSTANTIABLE,\
  INSTEAD,\
  INT,\
  INTEGER,\
  INTERSECT,\
  INTERVAL,\
  INTO,\
  INVOKER,\
  IS,\
  ISNULL,\
  ISOLATION,\
  ITERATE,\
  JOIN,\
  K,\
  KEY,\
  KEY_MEMBER,\
  KEY_TYPE,\
  LANCOMPILER,\
  LANGUAGE,\
  LARGE,\
  LAST,\
  LATERAL,\
  LEADING,\
  LEFT,\
  LENGTH,\
  LESS,\
  LEVEL,\
  LIKE,\
  LIMIT,\
  LISTEN,\
  LOAD,\
  LOCAL,\
  LOCALTIME,\
  LOCALTIMESTAMP,\
  LOCATION,\
  LOCATOR,\
  LOCK,\
  LOWER,\
  M,\
  MAP,\
  MATCH,\
  MAX,\
  MAXVALUE,\
  MESSAGE_LENGTH,\
  MESSAGE_OCTET_LENGTH,\
  MESSAGE_TEXT,\
  METHOD,\
  MIN,\
  MINUTE,\
  MINVALUE,\
  MOD,\
  MODE,\
  MODIFIES,\
  MODIFY,\
  MODULE,\
  MONTH,\
  MORE,\
  MOVE,\
  MUMPS,\
  NAME,\
  NAMES,\
  NATIONAL,\
  NATURAL,\
  NCHAR,\
  NCLOB,\
  NEW,\
  NEXT,\
  NO,\
  NOCREATEDB,\
  NOCREATEUSER,\
  NONE,\
  NOT,\
  NOTHING,\
  NOTIFY,\
  NOTNULL,\
  NULL,\
  NULLABLE,\
  NULLIF,\
  NUMBER,\
  NUMERIC,\
  OBJECT,\
  OCTET_LENGTH,\
  OF,\
  OFF,\
  OFFSET,\
  OIDS,\
  OLD,\
  ON,\
  ONLY,\
  OPEN,\
  OPERATION,\
  OPERATOR,\
  OPTION,\
  OPTIONS,\
  OR,\
  ORDER,\
  ORDINALITY,\
  OUT,\
  OUTER,\
  OUTPUT,\
  OVERLAPS,\
  OVERLAY,\
  OVERRIDING,\
  OWNER,\
  PAD,\
  PARAMETER,\
  PARAMETERS,\
  PARAMETER_MODE,\
  PARAMETER_NAME,\
  PARAMETER_ORDINAL_POSITION,\
  PARAMETER_SPECIFIC_CATALOG,\
  PARAMETER_SPECIFIC_NAME,\
  PARAMETER_SPECIFIC_SCHEMA,\
  PARTIAL,\
  PASCAL,\
  PASSWORD,\
  PATH,\
  PENDANT,\
  PLACING,\
  PLI,\
  POSITION,\
  POSTFIX,\
  PRECISION,\
  PREFIX,\
  PREORDER,\
  PREPARE,\
  PRESERVE,\
  PRIMARY,\
  PRIOR,\
  PRIVILEGES,\
  PROCEDURAL,\
  PROCEDURE,\
  PUBLIC,\
  READ,\
  READS,\
  REAL,\
  RECHECK,\
  RECURSIVE,\
  REF,\
  REFERENCES,\
  REFERENCING,\
  REINDEX,\
  RELATIVE,\
  RENAME,\
  REPEATABLE,\
  REPLACE,\
  RESET,\
  RESTART,\
  RESTRICT,\
  RESULT,\
  RETURN,\
  RETURNED_LENGTH,\
  RETURNED_OCTET_LENGTH,\
  RETURNED_SQLSTATE,\
  RETURNS,\
  REVOKE,\
  RIGHT,\
  ROLE,\
  ROLLBACK,\
  ROLLUP,\
  ROUTINE,\
  ROUTINE_CATALOG,\
  ROUTINE_NAME,\
  ROUTINE_SCHEMA,\
  ROW,\
  ROWS,\
  ROW_COUNT,\
  RULE,\
  SAVEPOINT,\
  SCALE,\
  SCHEMA,\
  SCHEMA_NAME,\
  SCOPE,\
  SCROLL,\
  SEARCH,\
  SECOND,\
  SECTION,\
  SECURITY,\
  SELECT,\
  SELF,\
  SENSITIVE,\
  SEQUENCE,\
  SERIALIZABLE,\
  SERVER_NAME,\
  SESSION,\
  SESSION_USER,\
  SET,\
  SETOF,\
  SETS,\
  SHARE,\
  SHOW,\
  SIMILAR,\
  SIMPLE,\
  SIZE,\
  SMALLINT,\
  SOME,\
  SOURCE,\
  SPACE,\
  SPECIFIC,\
  SPECIFICTYPE,\
  SPECIFIC_NAME,\
  SQL,\
  SQLCODE,\
  SQLERROR,\
  SQLEXCEPTION,\
  SQLSTATE,\
  SQLWARNING,\
  STABLE,\
  START,\
  STATE,\
  STATEMENT,\
  STATIC,\
  STATISTICS,\
  STDIN,\
  STDOUT,\
  STORAGE,\
  STRICT,\
  STRUCTURE,\
  STYLE,\
  SUBCLASS_ORIGIN,\
  SUBLIST,\
  SUBSTRING,\
  SUM,\
  SYMMETRIC,\
  SYSID,\
  SYSTEM,\
  SYSTEM_USER,\
  TABLE,\
  TABLE_NAME,\
  TEMP,\
  TEMPLATE,\
  TEMPORARY,\
  TERMINATE,\
  THAN,\
  THEN,\
  TIME,\
  TIMESTAMP,\
  TIMEZONE_HOUR,\
  TIMEZONE_MINUTE,\
  TO,\
  TOAST,\
  TRAILING,\
  TRANSACTION,\
  TRANSACTIONS_COMMITTED,\
  TRANSACTIONS_ROLLED_BACK,\
  TRANSACTION_ACTIVE,\
  TRANSFORM,\
  TRANSFORMS,\
  TRANSLATE,\
  TRANSLATION,\
  TREAT,\
  TRIGGER,\
  TRIGGER_CATALOG,\
  TRIGGER_NAME,\
  TRIGGER_SCHEMA,\
  TRIM,\
  TRUE,\
  TRUNCATE,\
  TRUSTED,\
  TYPE,\
  UNCOMMITTED,\
  UNDER,\
  UNENCRYPTED,\
  UNION,\
  UNIQUE,\
  UNKNOWN,\
  UNLISTEN,\
  UNNAMED,\
  UNNEST,\
  UNTIL,\
  UPDATE,\
  UPPER,\
  USAGE,\
  USER,\
  USER_DEFINED_TYPE_CATALOG,\
  USER_DEFINED_TYPE_NAME,\
  USER_DEFINED_TYPE_SCHEMA,\
  USING,\
  VACUUM,\
  VALID,\
  VALIDATOR,\
  VALUE,\
  VALUES,\
  VARCHAR,\
  VARIABLE,\
  VARYING,\
  VERBOSE,\
  VERSION,\
  VIEW,\
  VOLATILE,\
  WHEN,\
  WHENEVER,\
  WHERE,\
  WITH,\
  WITHOUT,\
  WORK,\
  WRITE,\
  YEAR,\
  ZONE

# The character to append to attribute names to avoid exceptions due to
# clashes between keywords and attribute names
KeywordsMaskChar=_

#flags for loading and saving instances using DatabaseLoader/Saver
nominalToStringLimit=50
idColumn=auto_generated_id