The older FILE_COPY strategy is also available. This is the most efficient strategy in cases where the template database is small, and therefore it is the default. If the WAL_LOG strategy is used, the database will be copied block by block and each block will be separately written to the write-ahead log. Strategy to be used in creating the new database. The character sets supported by the PostgreSQL server are described in Section 24.3.1. 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). encoding #Ĭharacter set encoding to use in the new database. The name of the template from which to create the new database, or DEFAULT to use the default template ( template1). To create a database owned by another role, you must be able to SET ROLE to that role. The role name of the user who will own the new database, or DEFAULT to use the default (namely, the user executing the command).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |