SereneDB Environment

SereneDB provides a number of functions and PRAGMA options to retrieve information on the running SereneDB instance and its environment.

Version

The version() function returns the version number of SereneDB.

SQL

SELECT version() AS version;

 version
------------------------------------
 PostgreSQL 18.3 (SereneDB 26.06.0)

Using a PRAGMA:

SQL

PRAGMA version;

 library_version | source_id  | codename
-----------------+------------+---------------------
 v1.6.0-dev7012  | 5212023fb8 | Development Version

Platform

The platform information consists of the operating system, system architecture, and, optionally, the compiler. To retrieve the platform, use the following PRAGMA:

SQL

PRAGMA platform;

 platform
-------------
 linux_amd64

The platform string combines the operating system and architecture — for example osx_arm64 on macOS with Apple Silicon, windows_amd64 on Windows on AMD64, or linux_arm64 on Ubuntu Linux on ARM64.

Meta Table Functions

SereneDB has the following built-in table functions to obtain metadata about available catalog objects:

• sdb_columns(): columns
• sdb_constraints(): constraints
• sdb_databases(): lists the databases that are accessible from within the current SereneDB process
• sdb_dependencies(): dependencies between objects
• sdb_extensions(): extensions
• sdb_functions(): functions
• sdb_indexes(): secondary indexes
• sdb_keywords(): SereneDB's keywords and reserved words
• sdb_optimizers(): the available optimization rules in the SereneDB instance
• sdb_schemas(): schemas
• sdb_sequences(): sequences
• sdb_settings(): settings
• sdb_tables(): base tables
• sdb_temporary_files(): the temporary files SereneDB has written to disk, to offload data from memory
• sdb_types(): data types
• sdb_views(): views