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
Disable 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 MoreDisplay the Number of Tablets (Shards) for a Table
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 […]
Read More