Hi All,
I have a question about pg_class column relpartbound would like to get some information. I am running postgresql v10, from pg_class column relpartbound I can see the internal representation of the partition. Is there a way or how to interpreter the internal representation? Below is what I see from replartbound. Thank you very much,
"{PARTITIONBOUNDSPEC :strategy r :listdatums <> :lowerdatums ({PARTITIONRANGEDATUM :kind 0 :value {CONST :consttype 701 :consttypmod -1 :constcollid 0 :constlen 8 :constbyval true :constisnull false :location 125 :constvalue 8 [ 0 0 0 0 -88 -122 8 65 ]} :location 125}) :upperdatums ({PARTITIONRANGEDATUM :kind 0 :value {CONST :consttype 701 :consttypmod -1 :constcollid 0 :constlen 8 :constbyval true :constisnull false :location 139 :constvalue 8 [ 0 0 0 0 -56 -119 8 65 ]} :location 139}) :location 119}"
Garry