SQL Server PostgreSQL terminology
From PostgreSQL wiki
Jump to navigationJump to search
SQL Server -> PostgreSQL terminology
| SQL Server term | PostgreSQL term |
|---|---|
| Instance | Cluster |
| Schema | Schema |
| Database | Database |
| User | Login role |
| Table | Relation or Table |
| Indexed View | Materialized View |
| Square brackets | Double quote (Identifiers and Key Words) |
| Buffer Pool | shared_buffers |
| User connections | max_connections |
| Dedicated administrator connection (DAC) | superuser_reserved_connections |
| File locations | data_directory |
| DBMS (Database Management System) | ORDBMS (Object Relational Database Management System) |
| Query Cache | N/A |
| Query Store | N/A |
| JSON | JSON & JSON types |
| Licensing | PostgreSQL License |
| Transaction Log | WAL (Write Ahead Log) |
| GETDATE() | CURRENT_TIMESTAMP (returns timestamptz) |
| CURRENT_TIMESTAMP | CURRENT_TIMESTAMP (returns timestamptz) |
| DATEADD(day, 1, '2022-01-01') | '2022-01-01'::date + '1 day'::interval |
| MERGE | INSERT ... ON CONFLICT & MERGE (PG15+) |
| SELECT * FROM information_schema.tables | \dt (in psql) SELECT * FROM information_schema.tables (in general) |
| SELECT * from sys.databases | \l (in psql) SELECT * FROM pg_catalog.pg_database (in general, information_schema is limited to the current database) |
| EXEC sp_help 'dbo.table_name' | \d table (in psql, other tools vary) |
