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.