Skip to content

SQL Reference

ClapDB SQL for Relational Query

ClapDB Support Relational Query with SQL commands. You can use SQL commands to query data from ClapDB.

Support Data Types

check this Data Types for supported data types.

ClapDB support some new modern datatypes that was not supported by traditional databases, such as int128, uint16, uint32, uint64, uint128.

Materialized View / Join

  1. ClapDB Free / Pro doesn’t support Materialized View.
  2. ClapDB Free / Pro doesn’t support Join.

you can double check postgres compatible for the compatibility with PostgreSQL.

Mathematical Functions and Operators

check the PostgreSQL mathematical functions for supported mathematical functions and operators.