The syntax : CREATE SYNONYM may not be available in Postgres while migrating from Oracle. But this does not mean that the feature is not possible in PostgreSQL. There are indeed better features upon leveraging search_path and VIEWS appropriately.