From: | Hans Ginzel <hans(at)matfyz(dot)cz> |
---|---|
To: | <pgsql-novice(at)postgresql(dot)org> |
Cc: | amul sul <sul_amul(at)yahoo(dot)co(dot)in> |
Subject: | Re: view without definition in information_schema.Views |
Date: | 2015-07-01 13:01:16 |
Message-ID: | 6b68e50bbcc4ed9ec7aacf69f53a853b@artax.karlin.mff.cuni.cz |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Dne 01.07.2015 14:04, amul sul napsal:
> Its in pg_view catalog.
Thank you. It works.
There is a "feature" in information_schema.Views, that definition is
null if the view is not owned by a currently enabled role. See
http://www.postgresql.org/docs/9.4/static/infoschema-views.html.
HG
> 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
From | Date | Subject | |
---|---|---|---|
Next Message | Ricardo Oliveira | 2015-07-07 18:59:00 | Help with db scenario |
Previous Message | amul sul | 2015-07-01 12:04:56 | Re: view without definition in information_schema.Views |