Database Reference
In-Depth Information
The dblink extension
The dblink extension is used to query external databases (PostgreSQL) from within
the current database session.
Almost the same functionally is available in PostgreSQL foreign data
wrapper ( postgres_fdw ) which is a more standard compliant.
The ile_fdw extension
It provides the file_fdw foreign data wrapper, which can be used to manipulate
data iles in the server's ile system. We already discussed this extension in
Chapter 11 , Foreign Data Wrapper .
Other available extensions
There are quite a few extensions available, and discussing all of them here is out
of the scope of this chapter. Interested readers can ind some more extensions
and information available on http://www.postgresql.org/docs/9.4/static/
contrib.html .
Summary
In this chapter, we learned about the features of extension, and extension versions.
We also learned about extension creation process as well as the process of altering
and dropping an extension. We also learned how to check the available extensions
and about additional supplied extensions, and in detail, we discussed the
adminpack , chkpass , citext , and cube extensions.
 
Search WWH ::




Custom Search