Table inheritance and column ordering question

From: Stephan Doliov <stephan(dot)doliov(at)gmail(dot)com>
To: pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Table inheritance and column ordering question
Date: 2019-08-11 19:36:10
Message-ID: CAFOdmV_+GVDPwd2dUSExsUzXMd2wLZWVEN=_mbmbmsM2zaL5YQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi all,
I hope this is the right list for my question, if not, please let me know
to which list I should send the question.

I'd like to know whether there is any way to control the order of inherited
columns?

This is purely an issue of syntactic sugar for me. I'd like to be able to
do the following:

create table my_standard_metadata (created_ts timestamp default now() not
null, updated_ts timestamp, deactived_ts timestamp);

create table foo (field1 text, field2 text) inherits (my_standard_metadata);

Currently, this results in:

postgres=# \d foo
Table "public.foo"
Column | Type | Collation | Nullable |
Default
--------------+-----------------------------+-----------+----------+---------
created_ts | timestamp without time zone | | not null | now()
updated_ts | timestamp without time zone | | |
deactived_ts | timestamp without time zone | | |
field1 | text | | |
field2 | text | | |
Indexes:
"foo_pkey" PRIMARY KEY, btree (email)
Inherits: my_standard_metadata

and have the resulting table be described as follows

postgres=# \d foo
Table "public.foo"
Column | Type | Collation | Nullable |
Default
--------------+-----------------------------+-----------+----------+---------
field1 | text | | |
field2 | text | | |
created_ts | timestamp without time zone | | not null | now()
updated_ts | timestamp without time zone | | |
deactived_ts | timestamp without time zone | | |
Indexes:
"foo_pkey" PRIMARY KEY, btree (email)
Inherits: my_standard_metadata

Is what I am thinking of worth pursuing? Or does it misuse the concept of
inheritance in the postgres context?

Thanks for any thoughts!
-Steve

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jonathan S. Katz 2019-08-11 19:46:46 Re: Add "password_protocol" connection parameter to libpq
Previous Message Tom Lane 2019-08-11 19:12:44 Re: Undocumented PQdisplayTuples and PQprintTuples in libpq