View definition truncated in information_schema

Поиск
Список
Период
Сортировка
От Eric E
Тема View definition truncated in information_schema
Дата
Msg-id 41F9205B.6030506@bonbon.net
обсуждение исходный текст
Ответы Re: View definition truncated in information_schema  (Michael Fuhr <mike@fuhr.org>)
Список 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

В списке pgsql-general по дате отправления:

Предыдущее
От: Shawn Harrison
Дата:
Сообщение: Re: Extended unit
Следующее
От: Terry Lee Tucker
Дата:
Сообщение: Re: pg_dump shell script with ~/.pgpass