amazon-web-servicesamazon-redshiftdblink

Does Amazon Redshift support extension dblink?

CREATE EXTENSION dblink;

I tried to create an extension dblink in AWS, but I receive this error.

ERROR: syntax error at or near "EXTENSION" LINE 1: create extension dblink;

Solution

  • Yes and No.

    Amazon Redshift itself does not provide dblink. However, you can install dblink on a different PostgreSQL server and use it to connect to Amazon Redshift.

    See: JOIN Amazon Redshift AND Amazon RDS PostgreSQL WITH dblink