Table of Contents
Create Database PostgreSQL Dialog Help
Valentina Studio provides the “Create PostgreSQL Dayabase” dialog, giving you the possibility to define a number of parameters for new database.
The options are divided into 2 groups:
- General
- Expert
General
In the “General” group, you can define name and directory of the new database
- Name – Enter the name of the new database.
- Comment – The comment for the new database.
Expert
- Character Type – Character classification to use in the new database. This affects the categorization of characters, e.g. lower, upper and digit. The default is to use the character classification of the template database.
- Collation – Collation order (LC_COLLATE) to use in the new database. This affects the sort order applied to strings, e.g. in queries with ORDER BY, as well as the order used in indexes on text columns. The default is to use the collation order of the template database.
- Connect Limit – How many concurrent connections can be made to this database. -1 (the default) means no limit.
- Encoding – Character set encoding to use in the new database. Specify a string constant (e.g., 'SQL_ASCII'), or an integer encoding number, or DEFAULT to use the default encoding (namely, the encoding of the template database). The character sets supported by the PostgreSQL server are described in official documentation.