@sql-extra/alter-database v0.1.4

Change the attributes of a database (ALTER DATABASE).

const alterDatabase = require('@sql-extra/alter-database');
// alterDatabase.renameTo(<name>, <new_name>)
// alterDatabase.ownerTo(<name>, <new_owner>)
// alterDatabase.setTablespace(<name>, <new_default_tablespace>)
// alterDatabase.set(<name>, <configuration_parameter>, [value=DEFAULT])
// alterDatabase.setFromCurrent(<name>, <configuration_parameter>)
// alterDatabase.reset(<name>, <configuration_parameter>)
// alterDatabase.resetAll(<name>)
// alterDatabase(<name>, <options>)
// -> SQL query


alterDatabase('test', {allowConnections: true, connectionLimit: 32});
// ALTER DATABASE "test" WITH ALLOW_CONNECTIONS true;
// ALTER DATABASE "test" WITH CONNECTION LIMIT 32;

alterDatabase.renameTo('test', 'mytest');
// ALTER DATABASE "test" RENAME TO "mytest";

alterDatabase.ownerTo('test', 'nagpur');
// ALTER DATABASE "test" OWNER TO "nagpur";

alterDatabase.setTablespace('test', 'mytablespace');
// ALTER DATABASE "test" SET TABLESPACE "mytablespace";

alterDatabase.set('test', 'enable_indexscan', 'off');
// ALTER DATABASE "test" SET enable_indexscan TO off;

alterDatabase.setFromCurrent('test', 'enable_indexscan');
// ALTER DATABASE "test" SET enable_indexscan FROM CURRENT;

alterDatabase.reset('test', 'enable_indexscan');
// ALTER DATABASE "test" RESET enable_indexscan;

alterDatabase.resetAll('test');
// ALTER DATABASE "test" RESET ALL;