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
Last activity: Mar 5, 2025, 10:07 PM