13 points | by gabrielmouallem 3 days ago ago
2 comments
Do I get a superuser? Can I install any extensions I want?
Yes, the 'app' user you connect with has SUPERUSER rights, so you can run CREATE EXTENSION.
You can only install extensions that are already built into the PostgreSQL image we use (supabase/postgres:latest).
Based on that image, the available extensions include:
amcheck, autoinc, bloom, btree_gin, btree_gist, citext, cube, dblink, dict_int, dict_xsyn, earthdistance, file_fdw, fuzzystrmatch, hstore, insert_username, intagg, intarray, isn, lo, ltree, moddatetime, pgcrypto, plpgsql, uuid-ossp, and several others.
If you need an extension not included in this list, we would need to use a custom database image.
__________
Use the code DBSONMETAL and get 30% off for the next 12 months.
That makes this database — already significantly cheaper than other providers like DigitalOcean, Neon, and Render — almost unbeatable in price.
Do I get a superuser? Can I install any extensions I want?
Yes, the 'app' user you connect with has SUPERUSER rights, so you can run CREATE EXTENSION.
You can only install extensions that are already built into the PostgreSQL image we use (supabase/postgres:latest).
Based on that image, the available extensions include:
amcheck, autoinc, bloom, btree_gin, btree_gist, citext, cube, dblink, dict_int, dict_xsyn, earthdistance, file_fdw, fuzzystrmatch, hstore, insert_username, intagg, intarray, isn, lo, ltree, moddatetime, pgcrypto, plpgsql, uuid-ossp, and several others.
If you need an extension not included in this list, we would need to use a custom database image.
__________
Use the code DBSONMETAL and get 30% off for the next 12 months.
That makes this database — already significantly cheaper than other providers like DigitalOcean, Neon, and Render — almost unbeatable in price.