Error running pgjwt--0.0.1.sql

michelp / pgjwt

PostgreSQL implementation of JWT (JSON Web Tokens)

MIT License

368 stars 60 forks source link

Error running pgjwt--0.0.1.sql #9

Closed NickEmpetvee closed 6 years ago

NickEmpetvee commented 6 years ago

Hi there.

When I remove the first line of this file and try to execute the SQL in my Windows database (as suggested in https://github.com/michelp/pgjwt/issues/7) I get the following error:

ERROR:  syntax error at or near "."
LINE 27: SELECT @extschema@.url_encode(hmac(signables, secret, alg.id...
                           ^
SQL state: 42601
Character: 906

Any thoughts on how I might resolve?

Cheers!

NickEmpetvee commented 6 years ago

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.