If you have some data sitting in an external file and would like to use it in your database queries, you can […]

In YugabyteDB’s YSQL API, the interval data type is used to store and manipulate a time period. Examples: yugabyte=# SELECT ‘1 Minute […]

Using the YSQL API, temporary tables exist in their own unique schema, so you can’t assign a schema name when you create […]

By default, YugabyteDB presplits a table in ysql_num_shards_per_tserver * num_of_tserver shards.  We can display the number of tablets for a table using the […]

The version() built-in function returns both the supported PostgreSQL version and the version of YugabyteDB. If you are just interested in the […]