Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

How To replace view : too long view_definition

Hi.
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)
But can't.

We await answers from the experts.

Best Answer

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.