

At that time, you need need to run createdb command from your PostgreSQL installation path. This kind of error may occur when PostgreSQL is not installed correctly. The default is -1, i.e., unlimited.Ĭommon Errors while using the createdb command Error Use this option to specify the maximum concurrent connections to the new database. The default is the template database’s tablespace. Using this option you can specify the tablespace name for the new database.

It affects the categorization, e.g., digit, lower and upper.

It specifies the character classification for the new database. The collation parameter specifies the sort order of strings which affect the result of the ORDER BY clause while using a SELECT statement. This parameter allows specifying character set encoding for the new database. You can specify database template name from which you want to creates the new database. Use this parameter to define the the role name for the user who will own the new database. Although, you need to make sure that the database must be unique because If you attempt to create a new database with the same name as an existing database, PostgreSQL will display an error. Use this option to specify the name of the new database that you want to create. Here is complete Syntax to create a DB in PostgreSQL CREATE DATABASE db_nameĬONNECTION LIMIT = max_concurrent_connection Option Step 4) The right pane gives you the SQL used to create the Database. Step 3) DB is created and shown in the Object tree.
