Get partition column for a table in Greenplum

Asked 3 years ago

Active 9 days ago

Viewed 356 times

How can I find what the partitioning scheme is for a table? Is it in information_schema or in the pg_class related tables?

51.3k10 gold badges99 silver badges133 bronze badges

asked Jan 30 '17 at 15:24

PhilHibbs

4513 silver badges14 bronze badges

1

pg_partition and pg_partition_rule maybe? – a_horse_with_no_name Jan 30 '17 at 15:33
You got me heading in the right direction, @a_horse_with_no_name , pg_partition_columns is the table I need! Thanks. – PhilHibbs Jan 30 '17 at 16:14

add a comment |

1 Answer 1

Thanks to @a_horse_with_no_name for pointing me in the right direction, pg_partition_columns is the table I need.

answered Jan 30 '17 at 16:19

PhilHibbs

4513 silver badges14 bronze badges

add a comment |

Name

Required, but never shown

Post as a guest

Name

Required, but never shown

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy