postgresql create database different directory

It affects the classification of character e.g., lower, upper, and digit. Specify the character classification that the new database will use. It defaults to the LC_COLLATE of the template database. This parameter affects the sort order of string in the queries that contain the ORDER BY clause. Specify the collation order ( LC_COLLATE) that the new database will use. By default, PostgreSQL uses the template1 database as the template database if you don’t explicitly specify the template database.ĭetermine the character set encoding in the new database. Specify the template database from which the new database is created. If you omit the OWNER option, the owner of the database is the role that you use to execute the CREATE DATABASE statement. Then, specify one or more parameters for the new database.Īssign a role that will be the owner of the database.If you try to create a database whose name already exists, PostgreSQL will issue an error. The database name must be unique in the PostgreSQL database server. First, specify the name of the new database after the CREATE DATABASE keywords.To execute the CREATE DATABASE statement you need to have a superuser role or a special CREATEDB privilege. Code language: PostgreSQL SQL dialect and PL/pgSQL ( pgsql ) The following shows the syntax of the CREATE DATABASE statement: CREATE DATABASE database_name The CREATE DATABASE statement allows you to create a new PostgreSQL database. Introduction to PostgreSQL CREATE DATABASE statement

Summary: in this tutorial, you will learn how to use the PostgreSQL CREATE DATABASE statement to create new databases in the PostgreSQL database server.

Postgresql create database different directory