YugabyteDB is a distributed SQL database composed of one or more nodes. In YSQL you can list the nodes (hosts) in the […]
Read More
Set 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 MoreGenerate a Random String
Whenever you are populating table columns with dummy data you’ll probably need to generate some random strings. This is very easy in […]
Read More