I have a postgres 9.6 server with > 100 databases on it. When doing a mass-migrate, I use statements like this:
ALTER DATABASE mydatabase SET default_transaction_read_only = false;
Which works great. However, occasionally I get into a state where I'm not sure which databases are read only and which aren't. How do I query this parameter? I know how to query it server-wide:
But not at a database specific level.