Error running pgjwt--0.0.1.sql

[NickEmpetvee]

Hi there.

When I remove the first line of this file and try to execute the SQL in my Windows database (as suggested in #7) I get the following error:

ERROR:  syntax error at or near "."
LINE 27: SELECT @[email protected]_encode(hmac(signables, secret, alg.id...
                           ^
SQL state: 42601
Character: 906

Any thoughts on how I might resolve?

Cheers!

[NickEmpetvee]

Well it seems I resolved this. I put the files 'pgjwt.control' and 'pgjwt--0.0.1.sql' in the share\postgresql\extensions folder and ran the command CREATE EXTENSION pgwjwt CASCADE; and it seemed to do the trick.