I used to have fun with the amusing old Linux command Cowsay which inserts any input into a word bubble and draws an […]
Read MoreList the Servers in your Cluster
YugabyteDB is a distributed SQL database composed of one or more nodes. In YSQL you can list the nodes (hosts) in the […]
Read MoreSet Schema Search Path
Each user session has a search path of schemas. YugabyteDB uses this search path to find tables, views, stored procedures, etc. that are unqualified by their schema […]
Read MoreAnalyzing Queries with EXPLAIN
The EXPLAIN statement allows you to obtain the query execution plan generated by YSQL for a given SQL statement. The EXPLAIN command has a […]
Read MoreMove data from one table to another table in a single step
If you need to move data rows from one table to another table, you’d probably immediately consider an INSERT followed by a […]
Read More