[–] avi_vallarapu 3y ago ↗ 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. [–] avi_vallarapu 3y ago ↗ And with search_path being set not only at GLOBAL level, but also at User and Session level is one of the advantage in Postgres.
[–] avi_vallarapu 3y ago ↗ And with search_path being set not only at GLOBAL level, but also at User and Session level is one of the advantage in Postgres.
2 comments
[ 2.2 ms ] story [ 14.4 ms ] thread