Skip to content

Instantly share code, notes, and snippets.

@cowlicks

cowlicks/jwt_postgrahile_ad_hoc.sql

Created December 6, 2022 16:43
Show Gist options
  • Save cowlicks/86ca0bf4ed0ab6f989acb262566725c2 to your computer and use it in GitHub Desktop.
Save cowlicks/86ca0bf4ed0ab6f989acb262566725c2 to your computer and use it in GitHub Desktop.
Download ZIP
manually set email to run ad hoc pstgresql commands with user configured via postgraphile
Raw
jwt_postgrahile_ad_hoc.sql
BEGIN;
SET LOCAL "jwt.claims.whatever" to '[email protected]';
SELECT the_name_of_your_function('yo-10');
COMMIt;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment