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
DROP ALL TABLES IN A SCHEMA
While there isn’t a single command to drop all tables in a schema, you can easily accomplish that task by generating and […]
Read MoreLimit Column to a Single NULL Value
A unique index disallows duplicate values from being inserted into the indexed columns. But this does not apply to NULL values. Here […]
Read MoreUninstall a PostgreSQL Extension
PostgreSQL extension functionality allows for bundling multiple SQL objects together in a single package that can be loaded or removed from your database. […]
Read MoreComposite Data Types
A composite type represents the structure of a row or record; it is essentially just a list of field names and their data […]
Read More