How to work on a database other than the default one (named

postgres

)? The

CREATE DATABASE

command works. But the Table editor seems hard-coded to the default

postgres

database. Extensions can not be enabled on the created database. Did I miss something?

Hello ! This thread has been automatically created from your message in a ``few seconds ago``. Pinging @User so that they see this as well! Want to unsubscribe from this thread? Right-click the thread in Discord (or use the ... menu) and select Leave Thread to unsubscribe from future updates. Want to change the title? Use the

/title

command! We have solved your problem? Click the button below to archive it.

Since this is a hosted database this is one of the constraints that comes with it. Do you have a use case where you require the behaviour outlined above?

Baoshan (2022-03-26)

Thanks for the info you shared. I’m just exploring the possibilities and best practices. It is fine with me working on the

postgres

database.

Thread was archived by . Anyone can send a message to unarchive it.

I don't think there's anything stopping you from doing this. Just tried the commands

sql
CREATE DATABASE hello;
create extension postgis; -- on the new database

and it works as expected. although yeah, supabase's dashboard doesn't support this, but if you use a sql client like postico or just psql, everything should work as expected (other than postgrest, auth, and basically everything else that supabase adds...) you can change databases in psql using

\c DBNAME

(https://stackoverflow.com/questions/3949876/how-to-switch-databases-in-psql)

I’m unable to create the

unaccent

extension.