From: | Garry Chen <gc92(at)cornell(dot)edu> |
---|---|
To: | pgsql-novice <pgsql-novice(at)postgresql(dot)org> |
Subject: | Question about pg_class column relpartbound |
Date: | 2018-04-02 13:12:14 |
Message-ID: | 47C3C4A8-8CA1-4A23-B9DF-1CB33E24FD8C@cornell.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Keith | 2018-04-02 13:49:34 | Re: Question about pg_class column relpartbound |
Previous Message | David G. Johnston | 2018-03-28 18:58:28 | Re: Tables design question |