Publish a database table to the API Server

« Back to Recipes for typical tasks

---

PostgREST is currently set up to serve up all tables and views that are in one of two schemas:

• The api schema is served at https://api.sfcta.org/api
• The scratch schema is served at https://api.sfcta.org/scratch

IMPORTANT - Our policy is to ONLY publish VIEWS, not tables, in the api schema, to enforce read-only permissions coming from the outside. That way even if someone had the sfcta password they wouldn't be able to modify any important database tables.

To publish a table on scratch:

To create a view of a table, and publish that view on api: