How can I find what the partitioning scheme is for a table? Is it in information_schema or in the pg_class related tables?
Thanks to @a_horse_with_no_name for pointing me in the right direction, pg_partition_columns is the table I need.
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
Sign up to join this communityHow can I find what the partitioning scheme is for a table? Is it in information_schema or in the pg_class related tables?
Thanks to @a_horse_with_no_name for pointing me in the right direction, pg_partition_columns is the table I need.