Adding Boolean field to a view I have a view that is being used to export data from my database to a 3rd party system, I have been asked to add a Boolean flag to the view that can be updated if the record has been exported to the other system. Is this possible? If so, how can it be done?
To do that you need a column to say when is true or false.
You can change the schema view or the query that run against the view.

Just use a case clause

select *, case flag_column when 1 then 'TRUE' else 'FALSE' end as boolean_column from view


I suppose that is what you will need