incomplete information from query on pg_views [duplicate]
Solution 1:
In pgAdmin III, under Query tool options:
pgAdmin Query tool Options
Solution 2:
You want pg_get_viewdef
, but I suspect you'll have the same issue there. The problem is probably that the client application is truncating the returned query.
If you're using PgAdmin-III this is in the FAQ.
If you're using psql
this shouldn't happen.