PostgreSQL Adapter Restrictions

Note the following PostgreSQL Adapter restriction.

Case Sensitivity for Tables and Column Names

Adding quotes to a table/column name in PostgreSQL makes it case sensitive, while unquoted table/column names are automatically treated as lowercase. For example, FOO, foo, and "foo" are treated the same, but "Foo" is treated as a different table name. To ensure compatibility with Oracle Integration, always create tables and columns in lowercase without quotes.

For example:

CREATE TABLE employee (id int, name varchar(30)); 

Note:

There are overall service limits for Oracle Integration. A service limit is the quota or allowance set on a resource. See Service Limits.