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.