Moodle installations are generated from the same XML source files so the difference between installing on MySQL and PostGres is in the SQL syntax, e.g. create table and create indexes. A scheme like the one you gave the link to that was generated from PostGres would be just about identical. You can get some visualisations of the db scheme from here.
That site also includes all of the xml in a single page here