MySQL PostgreSQL terminology
From PostgreSQL wiki
Jump to navigationJump to searchMySQL 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) |