How To replace view : too long view_definition
Please tell me how to fix it.
1. Create View
CREATE VIEW public.VIEW_A AS SELET col1 as COLUMN1, ,,, col1000 AS COLUMN1000 FROM public.TABLE_A WHERE col1='20200801';
2. select views
SELECT * FROM v_catalog.views where table_name='VIEW_A';
-> The definition is too long and is interrupted in the middle.
To replace view, I want to get view_definition from views.(And replace where condition)
We await answers from the experts.