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 MoreList Node Status From the Command Line
The yb-admin utility, located in the bin directory of YugabyteDB home, provides a command line interface for administering clusters. Two of its many command options, list_all_masters […]
Read MoreDisable Foreign Key Constraint Checks with COPY
The COPY statement can be used to transfer data between tables and files. COPY TO copies from tables to files. COPY FROM […]
Read MoreUsing Session Variables
YugabyteDB lets you declare session variables and use them in a YSQL statement or stored procedure. Example: yugabyte=# SELECT * FROM test_schema.test_table; […]
Read MoreList Table Column Names and Data Types
In YSQL you can query the system table INFORMATION_SCHEMA.COLUMNS to list details about each of the columns in table. Example: yugabyte=# CREATE […]
Read More