Use SELECT current_database(); or \conninfo in psql.

A namespace to logically group tables, views, and functions.

Use CREATE INDEX index_name ON table(column);.

A binary format for storing JSON with indexing and performance improvements.

An open-source, object-relational database system known for reliability, extensibility, and SQL compliance.

Reusable SQL blocks stored and executed on the database server.

Use REVOKE SELECT ON table FROM user;.

A stored SQL query that acts like a virtual table.

A generator for creating unique numeric identifiers, often used for primary keys.

Use GRANT SELECT ON table TO user;.

Use to_tsvector and to_tsquery functions.

A temporary result set using WITH for readable, modular queries.

Use the psql command-line tool with proper credentials.

A user or group with certain database privileges.

B-tree, Hash, GIN, GiST, SP-GiST, BRIN.

Use pg_dump for backup and pg_restore for restoration.

Use pg_terminate_backend(pid) from pg_stat_activity.

Yes, available via AWS RDS, Google Cloud SQL, Azure, and more.

Use \c database_name.

CREATE USER username WITH PASSWORD 'password';

A location on disk for storing database objects.

Use \l or \list in psql.

Use \dt in psql.

PostgreSQL supports advanced features like window functions, CTEs, and full ACID compliance.

Integers, text, boolean, JSON, arrays, UUID, timestamps, and more.