Re: Adding an extra boolean column to "information_schema.columns" or "pg_attribute"
От | GPT |
---|---|
Тема | Re: Adding an extra boolean column to "information_schema.columns" or "pg_attribute" |
Дата | |
Msg-id | CADep2PPgC33fxDLPmH+U91bvzBECtFyu_RzCA4ZBo6MXTL+41A@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: Adding an extra boolean column to "information_schema.columns"or "pg_attribute" (Karsten Hilbert <Karsten.Hilbert@gmx.net>) |
Ответы |
Re: Adding an extra boolean column to "information_schema.columns"or "pg_attribute"
|
Список | pgsql-general |
Please visit the following link: https://stackoverflow.com/q/48028501/8895614 but thing may go further/deeper than it seems. Krds On 12/30/17, Karsten Hilbert <Karsten.Hilbert@gmx.net> wrote: > On Sat, Dec 30, 2017 at 08:17:34PM +0100, GPT wrote: > >> I would like to add an extra boolean attribute to table columns, >> something like NULL. Unfortunately Pg does not support such a feature: >> >> ADD ATTRIBUTE <attribute_name> TYPE <type_of_attribute> TO COLUMN >> <schema.table.column_name>; > ... >> I have already been suggested to use VIEW or dynamic SQL but I am >> looking something different. > > Can you explain why ? > > One thing that comes to mind is complex user types. > > Or columns of type table. > > Karsten > -- > GPG key ID E4071346 @ eu.pool.sks-keyservers.net > E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346 > >
В списке pgsql-general по дате отправления: