Question about pg_class column relpartbound

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

Responses

Browse pgsql-novice by date

  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