| 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: | Whole Thread | Raw Message | 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 |