Hacker Newsnew | past | comments | ask | show | jobs | submitlogin
Migration of Synonyms from Oracle to PostgreSQL (migops.com)
1 point by avi_vallarapu on Jan 24, 2023 | hide | past | favorite | 2 comments


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.


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.




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: