When exploring an Oracle schema, object groupings are provided in the database explorer window for Materialized Views as well as other Oracle specific object groups. Since PostgreSQL has the ability to create materialized views, I feel there should also be a Materialized Views group for PostgreSQL connections as well which includes all the available utilities to create, drop and view similar to the Oracle implementation. This would resolve a current issue where in Materialized views are not currently discoverable for a PostgreSQL connection in either the explorer or within the auto discover pop up window within the query analyzer. In addition, I feel a object grouping for foreign data wrapper (fdw) objects should also be created in the database explorer for PostgreSQL connections with the proper utilities as described above for Materialized Views. The fdw objects should also be available in the auto discover pop up window within the query analyzer.
Materialized Views are listed in the "View" folder, and they show up in the Query Windows auto-completion.
Foreign Data Wrappers :
http://wiki.postgresql.org/wiki/Foreign_data_wrappers#Multicorn_Foreign_Data_Wrappers
System Catalog Table :
http://www.postgresql.org/docs/9.4/static/catalog-pg-foreign-data-wrapper.html
CREATE FOREIGN DATA WRAPPER :
http://www.postgresql.org/docs/current/static/sql-createforeigndatawrapper.html
Foreign Data Wrappers :
http://wiki.postgresql.org/wiki/Foreign_data_wrappers#Multicorn_Foreign_Data_Wrappers
System Catalog Table :
http://www.postgresql.org/docs/9.4/static/catalog-pg-foreign-data-wrapper.html
CREATE FOREIGN DATA WRAPPER :
http://www.postgresql.org/docs/current/static/sql-createforeigndatawrapper.html
Issue #13914 |
Closed |
Incomplete |
Resolved |
Completion |
No due date |
No fixed build |
No time estimate |
Materialized Views are listed in the "View" folder, and they show up in the Query Windows auto-completion.