MySQL PostgreSQL terminology
From PostgreSQL wiki
Jump to navigationJump to search
MySQL PostgreSQL terminology
| MySQL term | PostgreSQL term |
|---|---|
| Instance | Cluster |
| Database | Schema |
| ? | Database |
| User | Login role |
| Table | Relation or Table |
| Cross-database query | Cross-schema query |
| Materialized View | Materialized View |
| Backticks | Single quote |
| bind-address | listen_addresses |
| key_buffer_size | shared_buffers |
| max_connections | max_connections and superuser_reserved_connections |
| datadir | data_directory |
| socket | unix_socket_directories and ff |
| DBMS (Database Management System) | ORDBMS (Object Relational Database Management System) |
| Query Cache | N/A |
| MyISAM | N/A (also see Table Access Method) |
| InnoDB | N/A (also see Table Access Method) |
| JSON | JSON & JSON types |
| GPL | PostgreSQL License |
| Undo Log | WAL (Write Ahead Log) |
| CURDATE() | CURRENT_DATE() |
| CURTIME() | CURRENT_TIME() |
| INSERT IGNORE / REPLACE | INSERT ... ON CONFLICT |
| SHOW TABLES | \dt (in psql) SELECT * FROM information_schema.tables (in general) |
| SHOW DATABASES | \l (in psql) SELECT * FROM pg_catalog.pg_database (in general, information_schema is limited to the current database) |
| DESC table | \d table (in psql, other tools vary) |
