Updated on 2022-11-18 GMT+08:00

DESCRIBE FORMATTED COLUMNS

Syntax

DESCRIBE FORMATTED [db_name.]table_name [PARTITION partition_spec] col_name

Description

This statement is used to describe the column information of a table or partition and collect statistics on the columns of specified tables or partitions.

Example

describe formatted show_table1 a;
  Describe Formatted Column   
------------------------------
 col_name             a       
 data_type            integer 
 min                          
 max                          
 num_nulls                    
 distinct_count       0       
 avg_col_len                  
 max_col_len                  
 num_trues                    
 num_falses                   
 comment                      
(1 row)