Postgres is a object orient database management system(dbms). mysql is just a basic dbms. now, the advantage of postgres is that you can consider any data as an object. You can easily create new databases/table with very less effort.

example: you can say "select * from table where city = "mahola" into maholatable;". this command creates a new table from the old table.

mysql does not provide this kind of feature. all advantages of the object oriented programming can be used in the postgres database.

so from programming and re-usability point of view, postgres is better than mysql.
Source(s):
http://www.postgresql.org
http://www.mysql.org

Permalink | Report