How to use (install) dblink in PostgreSQL?

by

Since PostgreSQL 9.1, installation of additional modules is simple. Registered extensions like dblink can be installed with CREATE EXTENSION:

CREATE EXTENSION dblink;

Installs into your default schema, which is public by default. Make sure your search_path is set properly before you run the command. The schema must be visible to all roles who have to work with it. See:

Alternatively, you can install to any schema of your choice with:

CREATE EXTENSION dblink SCHEMA extensions;

See:

Run once per database. Or run it in the standard system database template1 to add it to every newly created DB automatically. Details in the manual.

You need to have the files providing the module installed on the server first. For Debian and derivatives this would be the package postgresql-contrib-9.1 – for PostgreSQL 9.1, obviously. Since Postgres 10, there is just a postgresql-contrib metapackage.

More Related Contents:

  1. postgresql: INSERT INTO … (SELECT * …)
  2. Postgres Error: More than one row returned by a subquery used as an expression
  3. PostgreSQL “Column does not exist” but it actually does
  4. Is SELECT or INSERT in a function prone to race conditions?
  5. Any downsides of using data type “text” for storing strings?
  6. Index for finding an element in a JSON array
  7. Query for array elements inside JSON type
  8. Calculating Cumulative Sum in PostgreSQL
  9. Best way to check for “empty or null value”
  10. How to avoid multiple function evals with the (func()).* syntax in a query?
  11. Time zone storage in data type “timestamp with time zone”
  12. Is there something like a zip() function in PostgreSQL that combines two arrays?
  13. Serial numbers per group of rows for compound key
  14. PostgreSQL parameterized Order By / Limit in table function
  15. Postgres analogue to CROSS APPLY in SQL Server
  16. Get the default values of table columns in Postgres?
  17. Division of integers returns 0
  18. PostgreSQL: how to convert from Unix epoch to date?
  19. Postgres not using index when index scan is much better option
  20. Postgres – Function to return the intersection of 2 ARRAYs?
  21. How to store array or multiple values in one column
  22. convert Postgres geometry format to WKT
  23. Which datatype should be used for currency?
  24. How to return two columns with function
  25. Count cumulative total in Postgresql
  26. Prepared Statement on Postgresql in Rails
  27. SELECT DISTINCT is slower than expected on my table in PostgreSQL
  28. Return rows from INSERT with ON CONFLICT without needing to update
  29. PostgreSQL nested INSERTs / WITHs for foreign key insertions
  30. Fetch records that are non zero after the decimal point in PostgreSQL

Leave a Comment