Sample Header Ad - 728x90

Get postgres partitioned table structure by a select

0 votes
2 answers
5457 views
I'm looking for some SIMPLE SQL-based command to show me the partitioned table structure in postgres. Something like \d . All I find so far is by doing pgdump. db=> \d partitioned_table ERROR: column c.relhasoids does not exist LINE 1: ..., c.relhasindex, c.relhasrules, c.relhastriggers, c.relhasoi...
Asked by Nir (529 rep)
Apr 3, 2022, 06:13 AM
Last activity: Mar 5, 2025, 10:07 PM