Hacker News
new
|
past
|
comments
|
ask
|
show
|
jobs
|
submit
login
Migration of Synonyms from Oracle to PostgreSQL
(
migops.com
)
1 point
by
avi_vallarapu
on Jan 24, 2023
|
hide
|
past
|
favorite
|
2 comments
avi_vallarapu
on Jan 24, 2023
[–]
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
on Jan 24, 2023
|
parent
[–]
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: