View definition truncated in information_schema

[Eric E <whalesuit@xxxxxxxxxx>]

Hi all,
   I'm trying to retrieve the SQL definition of a view from 
information_schema via:
SELECT view_definition FROM information_schema.views WHERE
table_name = 'viewname';
   It appears the definition returned is truncated at a fixed number of 
characters - for this view it's 7650.
Does anybody know where this problem is in information_schema, or in the 
actual storage of the text definition.  If it's the former, is there a 
way I can query the text definition directly?

This occurs in both server versions 8.0 and v7.4.1, BTW.

Many thanks,

Eric

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
   (send "unregister YourEmailAddressHere" to majordomo@xxxxxxxxxxxxxx)