view without definition in information_schema.Views

From: Hans Ginzel <hans(at)matfyz(dot)cz>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: view without definition in information_schema.Views
Date: 2015-07-01 11:23:31
Message-ID: 48726238f88a2d015c3e63b4b4cccf4b@artax.karlin.mff.cuni.cz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message amul sul 2015-07-01 12:04:56 Re: view without definition in information_schema.Views
Previous Message Stefano Mioli 2015-06-30 17:54:14 Locking issues under transaction