createDATABASE: Generate a PostgreSQL CREATE DATABASE statement, optionally execute the statement if con is not NULL.

Description

Generate a PostgreSQL CREATE DATABASE statement, optionally execute the statement if con is not NULL.

Usage

createDATABASE(
  name,
  owner = NULL,
  template = NULL,
  encoding = NULL,
  locale = NULL,
  lc_collate = NULL,
  lc_ctype = NULL,
  tablespace = NULL,
  allow_connections = NULL,
  connection_limit = NULL,
  is_template = NULL,
  con = NULL
)

Value

A string, PostgreSQL CREATE DATABASE statement; or the results retrieved by DBI::dbSendQuery after executing the statement.

Arguments

name: A string, the "name" parameter for PostgreSQL CREATE DATABASE.
owner: A string, the "user_name" parameter for PostgreSQL CREATE DATABASE.
template: A string, the "template" parameter for PostgreSQL CREATE DATABASE.
encoding: A string, the "encoding" parameter for PostgreSQL CREATE DATABASE.
locale: A string, the "locale" parameter for PostgreSQL CREATE DATABASE
lc_collate: A string, the "lc_collate" parameter for PostgreSQL CREATE DATABASE.
lc_ctype: A string, the "lc_ctype" parameter for PostgreSQL CREATE DATABASE.
tablespace: A string, the "tablespace_name" parameter for PostgreSQL CREATE DATABASE.
allow_connections: A string, the "allowconn" parameter for PostgreSQL CREATE DATABASE.
connection_limit: A string, the "connlimit" parameter for PostgreSQL CREATE DATABASE.
is_template: A string, the "istemplate" parameter for PostgreSQL CREATE DATABASE.
con: A database connection that can be passed to DBI::dbSendQuery/DBI::dbGetQuery.

Examples

Run this code

createDATABASE("dbTest01")

Run the code above in your browser using DataLab