The Postgres extension hstore implements a new data type (HSTORE) for storing key-value pairs in a single value. The hstore data type […]
Read MoreAccess Data In An External File Like a Database Table
If you have some data sitting in an external file and would like to use it in your database queries, you can […]
Read MoreSimplify String Literals with Dollar-Quoted String Literals in YSQL
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 More