Difference between revisions of "Postgrest auth"
Jump to navigation
Jump to search
| Line 10: | Line 10: | ||
\x; | \x; | ||
\du; | \du; | ||
| + | ALTER ROLE foo SET search_path = public, api; | ||
select * from pg_db_role_setting; | select * from pg_db_role_setting; | ||
SELECT * FROM pg_roles; | SELECT * FROM pg_roles; | ||
select usename,useconfig from pg_shadow ; | select usename,useconfig from pg_shadow ; | ||
``` | ``` | ||
Latest revision as of 23:56, 4 May 2023
https://github.com/monacoremo/postgrest-sessions-example/blob/master/app.sql.md
https://github.com/alexandrevilain/postgrest-auth
https://www.npmjs.com/package/postgrest-auth
\x; \du; ALTER ROLE foo SET search_path = public, api; select * from pg_db_role_setting; SELECT * FROM pg_roles; select usename,useconfig from pg_shadow ;