Help Center/ GaussDB/ Developer Guide(Centralized_V2.0-8.x)/ FAQ/ How do I query the partition and index information of a partitioned table?
Updated on 2025-08-19 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