The standard syntax for specifying string literals can be difficult to understand. To allow more readable queries in such situations, YugabyteDB’s YSQL […]
Read MoreConvert an INTERVAL to Seconds
In YugabyteDB’s YSQL API, the interval data type is used to store and manipulate a time period. Examples: yugabyte=# SELECT ‘1 Minute […]
Read MoreDisplay IP Address of Host Specified Using YSQLSH
When you connect to YugabyteDB using the ysqlsh client, you typically provide a host name using the -h switch. Later you may […]
Read MoreQuery Data Between Databases In the Same Universe
Just as a single Postgres server process can manage multiple databases at the same time, Yugabyte allows you to create and manage […]
Read MoreDrop a YCQL Keyspace Which is Not Empty
In YCQL the DROP KEYSPACE statement is used remove a keyspace from the system. An error is raised if the specified keyspace […]
Read More