When a CREATE VIEW statement is issued in a session, the view’s ownership is assigned to the current session user. Example: yugabyte=# […]
Read MoreChange the Owner of a Sequence in YSQL
When you issue a CREATE SEQUENCE statement in a session, the current session user becomes the owner of the seqeunce. Example: yugabyte=# […]
Read MoreCheck for Invalid Indexes in YSQL
If an online CREATE INDEX command fails, an invalid index may be left behind. These indexes are not usable in queries, so […]
Read MoreConsolidate Data From YB Catalog Tables From All Nodes To One Node
System catalogs, also referred to as system tables or system views, are essential to the internal structure and management of the database, […]
Read MoreLoad Balance YSQLSH Connections
The ysqlsh CLI is the shell for interacting with the YugabyteDB YSQL API. The -h (or –host) flag specifies the host name […]
Read More