Re: Adding an extra boolean column to "information_schema.columns" or "pg_attribute" - Mailing list pgsql-general

From Tom Lane
Subject Re: Adding an extra boolean column to "information_schema.columns" or "pg_attribute"
Date
Msg-id 9707.1514666693@sss.pgh.pa.us
Whole thread Raw
In response to Adding an extra boolean column to "information_schema.columns" or "pg_attribute"  (GPT <gptmailinglists@gmail.com>)
Responses Re: Adding an extra boolean column to "information_schema.columns" or "pg_attribute"
List pgsql-general
GPT <gptmailinglists@gmail.com> writes:
> I would like to add an extra boolean attribute to table columns,

The contents of the information_schema views are specified by the SQL
standard (ISO 9075).  Since the entire point of having those views is to
have a standard-conformant way of accessing the information in the system
catalogs, adding nonstandard columns would rather defeat the purpose.
If you can persuade the relevant ISO standards committee that this is a
good idea, we will adopt the change when it appears in a published version
of that standard --- otherwise, it seems quite unlikely that we'd accept
a change to the view definition.

You'd probably be better off to define your own nonstandard view, IMO.

            regards, tom lane


pgsql-general by date:

Previous
From: PT
Date:
Subject: Re: Adding an extra boolean column to "information_schema.columns"or "pg_attribute"
Next
From: GPT
Date:
Subject: Re: Adding an extra boolean column to "information_schema.columns" or "pg_attribute"