View definition truncated in information_schema

From: Eric E <whalesuit(at)bonbon(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: View definition truncated in information_schema
Date: 2005-01-27 17:09:47
Message-ID: 41F9205B.6030506@bonbon.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2005-01-27 17:13:05 Re: pg_dump shell script with ~/.pgpass
Previous Message Terry Lee Tucker 2005-01-27 17:06:54 Re: pg_dump shell script with ~/.pgpass