Help Center/ GaussDB/ Centralized_8.x/ FAQ/ How do I query the partition and index information of a partitioned table?
Updated on 2024-06-03 GMT+08:00
View PDF

How do I query the partition and index information of a partitioned table?

Answer: You can use either of the following methods:
  • You can use the pg_get_tabledef() function to view the definition of a table. The returned information includes table creation SQL statements, comments, indexes, and constraints.
    Example: 
    gaussdb=#SELECT pg_get_tabledef('table_name');
  • You can query the pg_partition view for partition information and the pg_indexes view for index information.
Parent topic: FAQ