#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