PostgREST Quickstart

This page contains a quickstart to help you get PostgREST up and running with Postgres Container Apps on Crunchy Bridge. We recommend you start with the quickstart to get an understanding of container apps.

About PostgREST

From the project:

PostgREST is a standalone web server that turns your PostgreSQL database directly into a RESTful API. The structural constraints and permissions in the database determine the API endpoints and operations.

PostgREST with Postgres Container Apps Quickstart

First ensure you have Container Apps enabled with CREATE EXTENSION pgpodman;. Once enabled you’ll need your DATABASE_URL from Crunchy Bridge to include in the command. To start your PostgREST you can run:

SELECT run_container('-dt -p 5433:3000/tcp -e PGRST_DB_URI="<DATABASE_URL>" -e PGRST_DB_SCHEMA="public" -e PGRST_DB_ANON_ROLE="postgres" postgrest/postgrest');

Now you can visit your running PostgREST at your hostname:5433.