I want to make a key value store on a PostreSQL database with hstore — hstore key/value datatype. Is it possible on Opalstack?
I made a DB on opal6 with the name kvstore and then executed the SQL command:
CREATE EXTENSION hstore;
and got th reply:
Fout in query: ERROR: permission denied to create extension "hstore"
HINT: Must be superuser to create this extension.
Can anyone help me? Thx.