I don't think PostgreSQL is all too different for normal queries so you should be fine moving over the queries. I do think writing function blocks might be different though and it might be annoying if you need other people's packages.
Posted Using LeoFinance Beta
PostgresSQL is probably one of closest SQL clones to Oracle (closer than Microsoft SQL, for example). It is also very fast. And the docs for it are very good.