YugabyteDB is a distributed SQL database that’s compatible with PostgreSQL and built for high availability across multiple regions. For database administrators, pulling out […]
Read More
Extract Tablespace DDL in YugabyteDB using ysql_dumpall
YugabyteDB, a distributed SQL database with PostgreSQL compatibility, allows you to manage data across multiple regions while ensuring high availability. For database […]
Read MoreExtract YCQL Types Into DDL Commands
Migrating system metadata between YCQL Universes can be challenging since system keyspaces, such as system_schema, cannot be transferred using simple INSERT INTO […]
Read MoreExtract YCQL Roles and Grants Into DDL Commands
In the YBA Platform, only user-created YCQL keyspaces can currently be backed up and restored; system keyspaces and tables, including roles and […]
Read MoreChange the Owner of a View in YSQL
When a CREATE VIEW statement is issued in a session, the view’s ownership is assigned to the current session user. Example: yugabyte=# […]
Read More