| Oracle | MySQL | PostgreSQL | |
| Object-Relational | Object-Relational | ||
| Storage | ASM File System | File System | File System |
| SQL Standards | SQL-92, sub-set of SQL-92 | SQL-92 | SQL-92/99 |
| Binary Large | LONG RAW (2 GB), BLOB (4 GB) and BFILE | TINYBLOB, BLOB, MEDIUMBLOB, and LONGBLOB | Users should defie CREATE TYPE |
| Binay Char | LONG (2 GB) and CLOB (4 GB) | TINYTEXT, TEXT, MEDIUMTEXT, and LONGTEXT | |
| User defined | yes | No | yes |
| Geometry data | Under spatial data type | NO | yes |
| Object relational | yes | NO | Yes |
| embeddable | no | yes | no |
| ORACLE | MYSQL | PostgreSQL | |
| Graph support | yes | no | yes |
| Native driver | C/C++ | php, c#, c, Ruby, python,java | PHP, C/C++, C# , Perl, Python, Ruby |
| locking | lock on write | no lock | MVCC |
| Transaction | yes | yes (innodb) | yes |
| ACID | yes | yes | yes |
| WSDL | yes | ||
| stored procedure | PL/SQL, Java, Oracle Call Interface, Pro*C/C++, and OO4O | Java, Perl, Python, Ruby, Tcl, C/C++, and its own PL/pgSQL | |
| (Table is not complete yet) | |||
|
http://www-css.fnal.gov/dsg/external/freeware/mysql-vs-pgsql.html
|
|||
| Geometry :
Data Example Oracle postgresql :pgisq http://workshops.boundlessgeo.com/postgis-intro/geometries.html |