| SQL adaptation guide for PostgreSQL 9.x / Data dictionary | |
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
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.