5 ms·
I would love it if PostgreSQL had packages. I have tons of PL/SQL that I would like to move from Oracle to PostgreSQL.
by forinti 6y ago
I would love it if PostgreSQL had packages.
I have tons of PL/SQL that I would like to move from Oracle to PostgreSQL.
- thornygreb 6y agoI used to miss packages but I mainly use schemas now to organize. Not the same I know but as good as it gets. I also add https://github.com/okbob/plpgsql_check https://github.com/okbob/plpgsql_check so that I can find bugs earlier since plpgsql is not compiled like pl/sql.
- forinti 6y agoThat is the best way, I think. And it even has some plusses: you could have a local tables/views. But, if you already have a lot of packages and a lot of schemas, separating your packages into schemas seems a bit daunting. Even more so if they have a lot of dependencies.