Question about pg_class column relpartbound - Mailing list pgsql-novice

From Garry Chen
Subject Question about pg_class column relpartbound
Date
Msg-id 47C3C4A8-8CA1-4A23-B9DF-1CB33E24FD8C@cornell.edu
Whole thread Raw
Responses Re: Question about pg_class column relpartbound
List pgsql-novice

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

pgsql-novice by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Tables design question
Next
From: Keith
Date:
Subject: Re: Question about pg_class column relpartbound