From: | amul sul <sul_amul(at)yahoo(dot)co(dot)in> |
---|---|
To: | Hans Ginzel <hans(at)matfyz(dot)cz>, "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: view without definition in information_schema.Views |
Date: | 2015-07-01 12:04:56 |
Message-ID: | 2072853617.345461.1435752296734.JavaMail.yahoo@mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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 <hans(at)matfyz(dot)cz> 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 (pgsql-novice(at)postgresql(dot)org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-novice
From | Date | Subject | |
---|---|---|---|
Next Message | Hans Ginzel | 2015-07-01 13:01:16 | Re: view without definition in information_schema.Views |
Previous Message | Hans Ginzel | 2015-07-01 11:23:31 | view without definition in information_schema.Views |