Обсуждение: Object browser does not show all views

Поиск
Список
Период
Сортировка

Object browser does not show all views

От
Johann Spies
Дата:
pgAdmin4 on Debian testing.

Postgresql 9.5 on the backend.

There are 36 views in one schema.  The object browser only shows the
last 9 and states that there are 9 views.

How can I be sure that the browser shows everything else?

Regards
Johann
-- 
Johann Spies                            Telefoon: 021-808 4699
Databestuurder /  Data manager        Faks: 021-883 3691

Sentrum vir Navorsing oor Evaluasie, Wetenskap en Tegnologie
Centre for Research on Evaluation, Science and Technology 
Universiteit Stellenbosch.

The integrity and confidentiality of this email is governed by these terms / Hierdie terme bepaal die integriteit en
vertroulikheidvan hierdie epos. http://www.sun.ac.za/emaildisclaimer

Re: Object browser does not show all views

От
Ashesh Vashi
Дата:

Hi Johann,

On Fri, Oct 14, 2016 at 1:22 PM, Johann Spies <jspies@sun.ac.za> wrote:
pgAdmin4 on Debian testing.

Postgresql 9.5 on the backend.

There are 36 views in one schema.  The object browser only shows the
last 9 and states that there are 9 views.
Are all these are views, and not materialized view?

--

Thanks & Regards,

Ashesh Vashi
EnterpriseDB INDIA: Enterprise PostgreSQL Company



How can I be sure that the browser shows everything else?

Regards
Johann
--
Johann Spies                            Telefoon: 021-808 4699
Databestuurder /  Data manager          Faks: 021-883 3691

Sentrum vir Navorsing oor Evaluasie, Wetenskap en Tegnologie
Centre for Research on Evaluation, Science and Technology
Universiteit Stellenbosch.

The integrity and confidentiality of this email is governed by these terms / Hierdie terme bepaal die integriteit en vertroulikheid van hierdie epos. http://www.sun.ac.za/emaildisclaimer


--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support

Re: Object browser does not show all views

От
Ashesh Vashi
Дата:
[Adding back the pgadmin-support...]

Hi Johann,

Please always reply to all, and please keep the pgadmin-support mail in CC for better support... 

On Fri, Oct 14, 2016 at 1:45 PM, Johann Spies <jspies@sun.ac.za> wrote:
On Fri, Oct 14, 2016 at 01:34:16PM +0530, Ashesh Vashi wrote:
> Hi Johann,
> On Fri, Oct 14, 2016 at 1:22 PM, Johann Spies <jspies@sun.ac.za> wrote:
>
> > pgAdmin4 on Debian testing.
> >
> > Postgresql 9.5 on the backend.
> >
> > There are 36 views in one schema.  The object browser only shows the
> > last 9 and states that there are 9 views.
> >
> Are all these are views, and not materialized view?
>

Most are materialized views.
You can see the materialized view in separate collection nodes called 'Materialized Views' (and, not in 'Views' collection node).


--

Thanks & Regards,

Ashesh Vashi
EnterpriseDB INDIA: Enterprise PostgreSQL Company



Regards
Johann
--
Johann Spies                            Telefoon: 021-808 4699
Databestuurder /  Data manager          Faks: 021-883 3691

Sentrum vir Navorsing oor Evaluasie, Wetenskap en Tegnologie
Centre for Research on Evaluation, Science and Technology
Universiteit Stellenbosch.

The integrity and confidentiality of this email is governed by these terms / Hierdie terme bepaal die integriteit en vertroulikheid van hierdie epos. http://www.sun.ac.za/emaildisclaimer

Re: Object browser does not show all views

От
Johann Spies
Дата:
> Please always reply to all, and please keep the pgadmin-support mail in CC
> for better support...

Apologies.  I did not see the Reply-To address was not the list.
> 
> You can see the materialized view in separate collection nodes called
> 'Materialized Views' (and, not in 'Views' collection node).

Another apology. I did not see that and just assumed the same category
as was used by pgadmin3.

Thanks.
Johann

-- 
Johann Spies                            Telefoon: 021-808 4699
Databestuurder /  Data manager        Faks: 021-883 3691

Sentrum vir Navorsing oor Evaluasie, Wetenskap en Tegnologie
Centre for Research on Evaluation, Science and Technology 
Universiteit Stellenbosch.

The integrity and confidentiality of this email is governed by these terms / Hierdie terme bepaal die integriteit en
vertroulikheidvan hierdie epos. http://www.sun.ac.za/emaildisclaimer