top | item 43608644 (no title) kennethallen | 10 months ago Do I get a superuser? Can I install any extensions I want? discuss order hn newest gabrielmouallem|10 months ago 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. acidmath|10 months ago [deleted]
gabrielmouallem|10 months ago 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.
gabrielmouallem|10 months ago
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.
acidmath|10 months ago
[deleted]