You can display the size of a YSQL table via the pg_table_size function. Example: yugabyte=# CREATE TABLE test (c1 INT); CREATE TABLE […]
Read More
YSQL Function to Determine Data Type of Text
YSQL inherits from Postgres the built-in function pg_typeof function which returns the OID of the data type of the value that is […]
Read MoreList Tablet Details for a YSQL Table From the Command Line
YugabyteDB automatically splits user YSQL tables into multiple shards, called tablets, using either a hash– or range– based strategy. You can see the Tablets […]
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 More