Name resolution of SQL objects

Informix® uses the following form to identify an SQL object:

[database[@dbservername]:][{owner|"owner"}.]identifier

With PostgreSQL, an object name takes the following form:

[owner.]identifier

Solution

As a general rule, to write portable SQL, you should only use simple database object names without any database, server or owner qualifier and without quoted identifiers.