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 More
Global Variables in YSQL
There are a lot of configuration parameters in YSQL that affect the behavior of the Yugabyte database system. The SHOW command in […]
Read MoreDisplay a Table’s TABLE_ID in YSQL
We can display a list of tables and their UUID (table_id) values by opening the YB-Master UI (<master_host>:7000/) and then clicking Tables in the navigation bar. […]
Read MoreEXPORT TABLE DDL (FROM YSQL)
In YSQL you can display the structure of a table, including indexes and constraints, by issuing the d table_name meta-command. yugabyte=# CREATE […]
Read More