In the previous tip GENERATE A RANDOM STRING, we learned how to create a function to do just that. In that version […]
Read More
Set a Default Tablespace for a Database
In PostgreSQL, tablespaces allow administrators to specify where on a disk specific tables and indexes should reside based on how users want […]
Read MoreConnect to YSQL with YSQLSH and a JDBC URL
ysqlsh is the shell for interacting with the YugabyteDB YSQL API. To connect to a database, you need the following information: the […]
Read MoreFind All Table Columns Storing Some Value
A long time ago a database developer asked me how she could produce a list of all table columns in the database […]
Read MoreMaintain a History of YSQL Commands
ysqlsh is a shell for interacting with the YugabyteDB YSQL API. By default, the commands that you type are kept in a […]
Read More