The Primary Key constraint is a means to uniquely identify a specific row in a table via one or more columns. To […]
Read MoreDisplay Unique Schema Name for Your Temp Tables
Using the YSQL API, temporary tables exist in their own unique schema, so you can’t assign a schema name when you create […]
Read MoreLoad TAB Delimited Files Using the COPY Command in YCQL
You can use the YCQL COPY command to load data from a CSV file into a table. The default expected delimiter of […]
Read MoreGet Help on a Specific YSQL Statement
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 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