PostgreSQL

ODBC Connection Tune

• ODBC Driver Installation
• ODBC Driver Configuration

Settings

• Source User Privileges

Troubleshooting

• There are No Columns in the Result Set
• Out of Memory while Reading Tuples
• Character with Byte Sequence <unicode sequence> in Encoding "UTF8" has No Equivalent in Encoding "WIN1252"

Settings

• Target User Privileges
• Bin Directory and Utilities to Perform Import

Troubleshooting

• ERROR: schema does not exist
• The process cannot access the file because it is being used by another process
• Psql: error: could not connect to server
• ERROR: User has no permission for table
• ERROR: Relation already exists
• No pg_hba.conf Entry for Host SSL Off
• FATAL: pg_hba.conf rejects connection for host [IP address] , user [user name], database [database name] [, SSL off]
• SSL Error: tlsv1 Alert Protocol Version
• Functions cannot have more than 100 arguments
• Result Sets Conversion to PostgreSQL
• BULK COLLECT Conversion to PostgreSQL
• Table Types Conversion from Oracle to PostgreSQL Using Arrays
• Functions with INOUT/OUT Parameters Conversion to PostgreSQL
• Comparison of Text Values when Migrating from Microsoft SQL Server to PostgreSQL
• GOTO Conversion to PostgreSQL
• Outer Apply and Cross Apply Conversion from Microsoft SQL Server to MySQL and PostgreSQL
• Timestamp Data Type Conversion from Microsoft SQL Server to PostgreSQL
• User Table-Values Types Conversion from Microsoft SQL Server to PostgreSQL
• Synonyms Conversion from Oracle to PostgreSQL
• Synonyms Conversion from DB2 LUW to PostgreSQL
• Must be Owner of Language plpgsql while Importing
• Preserving Source Database Case in Names of Objects for PostgreSQL as Target
• MS to PG case-insensitive comparison

Tool Specifics

• Advanced Options