incomplete information from query on pg_views [duplicate]

Solution 1:

In pgAdmin III, under Query tool options:

enter image description here

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.