📄️ Schemas
Create, inspect, rename and delete schemas in your Centia.io database through the Schema API, CLI or Web App, and see how schemas scope tables and sub-user access.
📄️ Tables
Create, inspect, rename, move and delete tables in a Centia.io schema through the Table API, with nested columns, indices and constraints in one request.
📄️ Columns
Add, inspect, alter and drop columns on Centia.io tables through the Column API. Set data types, nullability and defaults without writing DDL.
📄️ Indices
Create btree, gin, gist, brin and hash indices on Centia.io tables through the Index API to speed up queries and spatial operations, and inspect or drop them.
📄️ Constraints
Add primary key, unique, foreign key and check constraints to Centia.io tables through the Constraint API, and inspect or drop them again.
📄️ Sequences
Create, inspect, update and delete PostgreSQL sequences in a Centia.io schema through the Sequence API, typically to drive auto-incrementing primary keys.