Thread: Object browser does not show all views
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
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
[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
> 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