PostgREST is a web server that transforms PostgreSQL databases into RESTful APIs, offering tutorials, references, and examples for installation, configuration, and usage.

API PostgREST exposes three database objects of a schema as resources: tables, views and functions.

Tutorial 0 - Get it Running author: begriffs Welcome to PostgREST! In this pre-tutorial we’re going to get things running so you can create your first simple API. PostgREST is a standalone web server which …

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 …

PostgREST automatically serves a full OpenAPI description on the root path. This provides a list of all endpoints (tables, foreign tables, views, functions), along with supported HTTP verbs and example …

All tables and auto-updatable views can be modified through the API, subject to permissions of the requester’s database role. To create a row in a database table post a JSON object whose keys are …

Installation The release page has pre-compiled binaries for macOS, Windows, Linux and FreeBSD. The Linux binary is a static executable that can be run on any Linux distribution. You can also use your …

Building a Contacts List with PostgREST and Vue.js- In this video series, DigitalOcean shows how to build and deploy an Nginx + PostgREST(using a managed PostgreSQL database) + Vue.js webapp …

Such functions can perform any operations allowed by PostgreSQL (read data, modify data, and even DDL operations). To supply arguments in an API call, include a JSON object in the request payload …

Insert All tables and auto-updatable views can be modified through the API, subject to permissions of the requester’s database role. To create a row in a database table post a JSON object whose keys …