postgrest-docs
postgrest-docs copied to clipboard
PostgREST
This repo is archived and will be merged into postgrest/postgrest soon.
as postgres supports ```order by random()```, please add similar functionality to PostgREST --- **Edit**: Similar requests: - https://github.com/orgs/supabase/discussions/14609
Related to https://github.com/PostgREST/postgrest/issues/2781. I thought of adding the following to http://postgrest.org/en/stable/references/schema_cache.html#automatic-schema-cache-reloading ```sql IF pg_is_in_recovery() THEN PERFORM pg_terminate_backend(pid) FROM pg_stat_activity WHERE application_name ilike '%postgrest%'; ELSE NOTIFY pgrst, 'reload schema'; END IF;...
## Problem Since the move to [subpages inside API](https://postgrest.org/en/stable/references/api.html), seems our OOTB CRUD endpoints on tables/views are no longer visible: https://github.com/PostgREST/postgrest/discussions/2797 ## Solution Add a dedicated landing page instead of...
**Edit**: solution [below](https://github.com/PostgREST/postgrest-docs/issues/609#issuecomment-1522503119). Having: ```sql -- $ postgrest-with-postgresql-15 psql -- on nix-shell create table chat_messages( id text PRIMARY KEY , content text , workspace uuid ); create or replace function...
From gitter: > hi I recently started to use Postgres, and I am uploading a long CSV file which contains some errors, such as duplicates; Postgrest tells me that something...
Postrest documentation states that ``` Ensure also that your client application does not pass in any audience configuration ``` But on the other hand, Auth0 documentation (https://auth0.com/docs/api-auth/tutorials/verify-access-token) insists that an...
