pg-create-drop-db

Simple module for create if not exists or drop database.

Install

$ npm i pg-create-drop-db

Usage

create(options)

Creates a database if it does not exist.

const {create, drop}=require('pg-create-drop-db');

create({
    user: "postgres",
    pass: "postgres",
    host: "localhost",
    port: 5432,
    name: "db-name", //name for database
    database: "postgres" //the database through which the connection is made
})
.then(() => {
    //db created or exists
});

Option | Description | Default ------- | ------------------------------------------------- | --------- user | Directory to put all default forever log files | 'postgres' pass | Password | null host | Host | 'localhost' port | Port | 5432 name | The name of a database to create. | database | The database through which the connection is made | 'postgres' owner | The role name of the user who will own the new database, or DEFAULT to use the default (namely, the user executing the command). To create a database owned by another role, you must be a direct or indirect member of that role, or be a superuser. | encoding | | 'UTF-8'

drop(options)

Deletes the database.

const {create, drop}=require('pg-create-drop-db');

drop({
    user: "postgres",
    pass: "postgres",
    host: "localhost",
    port: 5432,
    name: "db-name", //name for database
    database: "postgres" //the database through which the connection is made
})
.then(() => {
    //db dropped
});

Option | Description | Default ------- | ------------------------------------------------- | --------- user | Directory to put all default forever log files | 'postgres' pass | Password | null host | Host | 'localhost' port | Port | 5432 name | The name of a database to drop. | database | The database through which the connection is made | 'postgres'