#Seems like INFORMIX-POSTGRESQL.cnv is obsolete? 

DOUBLE_TO_SINGLE_QUOTES
MATCHES_TO_GLOB
TABLE_ALIAS_AS
COLUMN_ALIAS_AS
MONEY_AS_DECIMAL
ANSI_UPDATE_SYNTAX
CONSTRAINT_NAME_BEFORE
SUBSTRING_FUNCTION = substr
CHAR_TO_DATETIME = DATETIME
CHAR_TO_INTERVAL = INTERVAL
DATETIME_EXTEND_FUNCTION=dt_extend
INTERVAL_EXTEND_FUNCTION=iv_extend
SELECT_INTO_TEMP_AS_CREATE_TEMP_AS

# Postgres doesn't have one of these - so fake one
DTYPE_ALIAS DATETIME DAY TO DAY=SMALLINT
DTYPE_ALIAS DATETIME DAY TO FRACTION(2)=CHAR(14)
DTYPE_ALIAS DATETIME DAY TO FRACTION=CHAR(14)
DTYPE_ALIAS DATETIME DAY TO HOUR=CHAR(5)
DTYPE_ALIAS DATETIME DAY TO MINUTE=CHAR(8)
DTYPE_ALIAS DATETIME DAY TO SECOND=CHAR(11)
DTYPE_ALIAS DATETIME HOUR TO FRACTION(2)=CHAR(11)
DTYPE_ALIAS DATETIME HOUR TO FRACTION=CHAR(11)
DTYPE_ALIAS DATETIME HOUR TO HOUR=SMALLINT
DTYPE_ALIAS DATETIME HOUR TO MINUTE=CHAR(5)
DTYPE_ALIAS DATETIME HOUR TO SECOND=CHAR(8)
DTYPE_ALIAS DATETIME MINUTE TO FRACTION(1)=CHAR(7)
DTYPE_ALIAS DATETIME MINUTE TO FRACTION=CHAR(8)
DTYPE_ALIAS DATETIME MINUTE TO MINUTE=SMALLINT
DTYPE_ALIAS DATETIME MINUTE TO SECOND=CHAR(5)
DTYPE_ALIAS DATETIME MONTH TO DAY=CHAR(5)
DTYPE_ALIAS DATETIME MONTH TO FRACTION(1)=CHAR(16)
DTYPE_ALIAS DATETIME MONTH TO FRACTION=CHAR(17)
DTYPE_ALIAS DATETIME MONTH TO HOUR=CHAR(8)
DTYPE_ALIAS DATETIME MONTH TO MINUTE=CHAR(11)
DTYPE_ALIAS DATETIME MONTH TO MONTH=SMALLINT
DTYPE_ALIAS DATETIME MONTH TO SECOND=CHAR(14)
DTYPE_ALIAS DATETIME SECOND TO FRACTION(2)=CHAR(4)
DTYPE_ALIAS DATETIME SECOND TO FRACTION=CHAR(4)
DTYPE_ALIAS DATETIME SECOND TO SECOND=SMALLINT
DTYPE_ALIAS DATETIME YEAR TO DAY=CHAR(10)  
DTYPE_ALIAS DATETIME YEAR TO FRACTION(2)=CHAR(20)
DTYPE_ALIAS DATETIME YEAR TO FRACTION(3)=CHAR(20)
DTYPE_ALIAS DATETIME YEAR TO FRACTION(5)=CHAR(20)
DTYPE_ALIAS DATETIME YEAR TO FRACTION=CHAR(20)
DTYPE_ALIAS DATETIME YEAR TO HOUR=CHAR(13)
DTYPE_ALIAS DATETIME YEAR TO MINUTE=CHAR(16)
DTYPE_ALIAS DATETIME YEAR TO MONTH=CHAR(7)
DTYPE_ALIAS DATETIME YEAR TO SECOND=CHAR(16)
DTYPE_ALIAS DATETIME YEAR TO YEAR=SMALLINT
DTYPE_ALIAS INTERVAL YEAR TO YEAR=CHAR(20)
DTYPE_ALIAS INTERVAL YEAR (4) TO YEAR=CHAR(20)
DTYPE_ALIAS INTERVAL YEAR TO MONTH=CHAR(20)
DTYPE_ALIAS INTERVAL YEAR (4) TO MONTH=CHAR(20)
DTYPE_ALIAS INTERVAL MONTH TO MONTH=CHAR(20)
DTYPE_ALIAS INTERVAL MONTH (2) TO MONTH=CHAR(20)
DTYPE_ALIAS INTERVAL DAY TO DAY=CHAR(20)
DTYPE_ALIAS INTERVAL DAY (2) TO DAY=CHAR(20)
DTYPE_ALIAS INTERVAL DAY TO HOUR=CHAR(20)
DTYPE_ALIAS INTERVAL DAY (2) TO HOUR=CHAR(20)
DTYPE_ALIAS INTERVAL DAY TO MINUTE=CHAR(20)
DTYPE_ALIAS INTERVAL DAY (2) TO MINUTE=CHAR(20)
DTYPE_ALIAS INTERVAL DAY TO SECOND=CHAR(20)
DTYPE_ALIAS INTERVAL DAY (2) TO SECOND=CHAR(20)
DTYPE_ALIAS INTERVAL DAY TO FRACTION=CHAR(20)
DTYPE_ALIAS INTERVAL DAY (2) TO FRACTION=CHAR(20)
DTYPE_ALIAS INTERVAL DAY TO FRACTION(2)=CHAR(20)
DTYPE_ALIAS INTERVAL DAY (2) TO FRACTION(2)=CHAR(20)
DTYPE_ALIAS INTERVAL HOUR TO HOUR=CHAR(20)
DTYPE_ALIAS INTERVAL HOUR (2) TO HOUR=CHAR(20)
DTYPE_ALIAS INTERVAL HOUR TO MINUTE=CHAR(20)
DTYPE_ALIAS INTERVAL HOUR (2) TO MINUTE=CHAR(20)
DTYPE_ALIAS INTERVAL HOUR TO SECOND=CHAR(20)
DTYPE_ALIAS INTERVAL HOUR (2) TO SECOND=CHAR(20)
DTYPE_ALIAS INTERVAL HOUR TO FRACTION=CHAR(20)
DTYPE_ALIAS INTERVAL HOUR (2) TO FRACTION=CHAR(20)
DTYPE_ALIAS INTERVAL HOUR TO FRACTION(2)=CHAR(20)
DTYPE_ALIAS INTERVAL HOUR (2) TO FRACTION(2)=CHAR(20)
DTYPE_ALIAS INTERVAL MINUTE TO MINUTE=CHAR(20)
DTYPE_ALIAS INTERVAL MINUTE (2) TO MINUTE=CHAR(20)
DTYPE_ALIAS INTERVAL MINUTE TO SECOND=CHAR(20)
DTYPE_ALIAS INTERVAL MINUTE (2) TO SECOND=CHAR(20)
DTYPE_ALIAS INTERVAL MINUTE TO FRACTION=CHAR(20)
DTYPE_ALIAS INTERVAL MINUTE (2) TO FRACTION=CHAR(20)
DTYPE_ALIAS INTERVAL MINUTE (2 ) TO FRACTION(1)=CHAR(20)
DTYPE_ALIAS INTERVAL MINUTE (2) TO FRACTION(1)=CHAR(20)
DTYPE_ALIAS INTERVAL SECOND TO SECOND=CHAR(20)
DTYPE_ALIAS INTERVAL SECOND (2) TO SECOND=CHAR(20)
DTYPE_ALIAS INTERVAL SECOND TO FRACTION=CHAR(20)
DTYPE_ALIAS INTERVAL SECOND (2) TO FRACTION=CHAR(20)
DTYPE_ALIAS INTERVAL SECOND TO FRACTION(2)=CHAR(20)
DTYPE_ALIAS INTERVAL SECOND (2) TO FRACTION(2)=CHAR(20)
DTYPE_ALIAS SERIAL=INTEGER PRIMARY KEY
DTYPE_ALIAS DECIMAL=REAL
OMIT_NO_LOG
# No obvious replacement for these - so effectively remove them
REPLACE_COMMAND SET EXPLAIN ON =
REPLACE_COMMAND SET EXPLAIN OFF =

# This is about as close as postgres gets to an update statistics...
REPLACE_COMMAND UPDATE STATISTICS = VACUUM

# We can only replace whole statements with a REPLACE_COMMAND
# so we need to use a REPLACE on its own for this one..
REPLACE UPDATE STATISTICS FOR TABLE  = VACUUM
OMIT_INDEX_CLUSTER
OMIT_INDEX_ORDER

REPLACE ROWID = oid

# Using $TODAY and $USER will take the Aubit4GL versions of these as text..
# Eg '01/01/2004' or 'aubit4gl'
REPLACE_SQLCONST TODAY = $TODAY
REPLACE_SQLCONST USER = $USER


# Remove any columns for an GRANT UPDATE (...) ...
SIMPLE_GRANT_UPDATE
SIMPLE_GRANT_SELECT

# Remove any (...) for serial (autoincrements) columns
NO_SERIAL_START_VALUE

RENAME_TABLE_AS_ALTER_TABLE
RENAME_COLUMN_AS_ALTER_TABLE

REPLACE_EXPR CURRENT YEAR TO SECOND=$CURRENT_YEAR_SECOND
REPLACE_EXPR CURRENT YEAR TO FRACTION(1)=$CURRENT_YEAR_FRACTION1
REPLACE_EXPR CURRENT YEAR TO FRACTION(2)=$CURRENT_YEAR_FRACTION2
REPLACE_EXPR CURRENT YEAR TO FRACTION(3)=$CURRENT_YEAR_FRACTION3
REPLACE_EXPR CURRENT YEAR TO FRACTION(4)=$CURRENT_YEAR_FRACTION4
REPLACE_EXPR CURRENT YEAR TO FRACTION(5)=$CURRENT_YEAR_FRACTION5


REPLACE_COMMAND SET EXPLAIN ON =
REPLACE_COMMAND SET EXPLAIN OFF =
REPLACE_COMMAND UPDATE STATISTICS = VACUUM
REPLACE_COMMAND SET ISOLATION TO DIRTY READ =
REPLACE_COMMAND SET ISOLATION TO REPEATABLE READ =
REPLACE_COMMAND SET ISOLATION TO CURSOR STABILITY =
REPLACE_COMMAND SET ISOLATION TO COMMITTED READ =
REPLACE_COMMAND SET LOCK MODE TO NOT WAIT =
REPLACE_COMMAND SET LOCK MODE TO WAIT =
REPLACE_COMMAND SET LOCK MODE TO WAIT %s =
ODBC_LONGVARCHAR_AS_CHAR