About openGauss, what is the command to view the table structure properties or the system table?For example, table details, index details, constraint information, partition table information, user information, statistics information, version information, etc.
About openGauss, what is the command to view the table structure properties or the system table?
88 views Asked by Qing At
1
The \d+ command shows the table properties, including the columns and their types and properties, indexes, constraints, rules, and triggers. It is functionally equivalent to the same command on PostgreSQL.
If you only need basic information then you can use \d instead.
For more information you can check this tutorial.