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 MoreNavigate Wide Query Output in YSQLSH Using Your Left and Right Arrow Keys
Using ysqlsh and annoyed by wrapping lines creating difficult-to-read outputs? Try setting the PAGER environment variable, when starting ysqlsh (then you’ll be […]
Read More