2 ms·
The correct answer is to just apply a view and enumerate the wanted column names once. Otherwise, dynamic column names (that's your search engine fodder) requi
by bmn__ 6y ago
The correct answer is to just apply a view and enumerate the wanted column names once.
Otherwise, dynamic column names (that's your search engine fodder) require introspection…
-- "Chinook" sample database
select column_name
from information_schema.columns
where table_name = 'Track'
except
select 'UnitPrice'
… coupled with the moral equivalent of PL/pgSQL `execute` (i.e. run-time eval) statement.
- djeiasbsbo 6y agoThanks for answering! Currently I do use views but it's just something I had wondered about. I mean, the information from the information_schema must be updated anyway when one deletes a column or table, so I thought maybe a function like that which looks it up could exist. I will try with PL/pgSQL, have long wanted to familiarise myself with it anyway.