Long-time Oracle user here. Yes, there are features missing. I expect that everything you can do in Oracle you can do in Postgres, but it would take considerabl

Long-time Oracle user here. Yes, there are features missing. I expect that everything you can do in Oracle you can do in Postgres, but it would take considerable effort to port your logic. One fairly small, fairly clean schema here has about 5500 lines of PL/SQL in package bodies. Postgresql does not have packages, though to be sure the packages I mention don't make much use of package state and so one could easily enough break out the individual functions and procedures. If you are an Oracle customer, and your applications make use of stored programs, moving to Postgres will require a fair bit of effort.