🐘
pREST
  • pRESTd
    • Who uses pREST
    • pRESTd Key Features
    • Contributing to pRESTd
    • pREST in the Media
    • Code of Conduct
    • Code of Ethics
  • Get pREST
    • Development Guide
    • Start with Docker
    • Start with Golang
    • Start with Homebrew
  • Get Started
    • Configuring pREST
    • CORS Support
    • Cache
    • Migrating
    • Permissions
  • API Reference
    • Custom Queries
    • Auth
    • Parameters
    • Advanced Queries
  • Deployment
    • Deploying with Docker
    • Deploy in Heroku
  • Plugins
    • Middleware Plugin
    • Endpoint Plugin
  • Integrations
    • Amazon Redshift
    • TimescaleDB
    • YugabyteDB
Powered by GitBook
On this page

Was this helpful?

Edit on GitHub
  1. Integrations

Amazon Redshift

PreviousIntegrationsNextTimescaleDB

Was this helpful?

Analyze all of your data with the fastest and most widely used cloud data warehouse.

Amazon Redshift is based on PostgreSQL. Amazon Redshift and PostgreSQL have a number of very important differences that you must be aware of as you design and develop your data warehouse applications.

Amazon Redshift is compatible with postgresql just use the ODBC connection in the environment variable DATABASE_URL with the parameter OpenSourceSubProtocolOverride to make pREST connect to the database.

DATABASE_URL=postgresql://localhost:5432/postgres?OpenSourceSubProtocolOverride=true
read more