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)

back to terminology