Get partition column for a table in Greenplum

Asked 2 years, 6 months ago

Active 2 months ago

Viewed 283 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?

45.9k9 gold badges90 silver badges122 bronze badges

asked Jan 30 '17 at 15:24

PhilHibbs

3212 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

3212 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