v.23.7New Feature
Aliases for current_database and new function current_schemas for PostgreSQL compatibility
Aliasescurrent_databaseand a new functioncurrent_schemasfor compatibility with PostgreSQL. #51076 (Pedro Riera).
Why it matters
This feature provides PostgreSQL compatibility by adding commonly used functionscurrent_database and current_schemas, allowing users to migrate or integrate queries more easily between ClickHouse and PostgreSQL environments.How to use it
Use the functioncurrent_database() to get the name of the current database, and current_schemas() to retrieve the current search path schemas, just as in PostgreSQL. These functions are available by default after upgrading ClickHouse to the version including this feature.