Re: view without definition in information_schema.Views - Mailing list pgsql-novice

Its in pg_view catalog.

Check more detail in PostgreSQL doc:
http://www.postgresql.org/docs/9.3/static/view-pg-views.html
 Regards,
Amul Sul



On Wednesday, 1 July 2015 4:55 PM, Hans Ginzel <[email protected]> wrote:



Hello!

I realised that there are views in information_schema.Views without
definition but \d+ psql command shows the definition. Where does the
definition live, please?

SELECT    *
FROM    information_schema.Views
WHERE    Table_Schema NOT IN ('pg_catalog', 'information_schema')
    AND View_Definition IS NULL
LIMIT    10;

Regards
Hans Ginzel



--
Sent via pgsql-novice mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-novice