You can get help on specific YSQL (i.e. PostgreSQL) statement with the h <command> meta-command. For example, I want alter add a […]
Read More
EXPORT 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 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 More