postgresql create empty database
By default, the new database will be created by cloning the standard system database template1. A different template can be specified by writing TEMPLATE ... ,The first database is always created by the initdb command when the data storage area is initialized. (See Section 17.2.) This database is called postgres. So to create the first "ordinary" database you can connect to postgres. ,In that case you can omit this step and skip ahead to the next section. To create a new database, in this example named mydb , you use the following command: ,CREATE DATABASE name ;. where name follows the usual rules for SQL identifiers. The current role automatically becomes the owner of the new database. ,CREATE DATABASE name;. where name follows the usual rules for SQL identifiers. The current role automatically becomes the owner of the new database. ,The first database is always created by the initdb command when the data storage area is initialized. (See Section 16.2.) This database is called postgres. So to create the first "ordinary" database you can connect to postgres. ,By default, the new database will be created by cloning the standard system database template1. A different template can be specified by writing TEMPLATE ...
| 相關軟體 PostgreSQL 資訊 | |
|---|---|
 postgresql create empty database 相關參考資料
PostgreSQL: Documentation: 9.1: CREATE DATABASE
By default, the new database will be created by cloning the standard system database template1. A different template can be specified by writing TEMPLATE ... https://www.postgresql.org PostgreSQL: Documentation: 9.5: Creating a Database
The first database is always created by the initdb command when the data storage area is initialized. (See Section 17.2.) This database is called postgres. So to create the first "ordinary" ... https://www.postgresql.org PostgreSQL: Documentation: 10: 1.3. Creating a Database
In that case you can omit this step and skip ahead to the next section. To create a new database, in this example named mydb , you use the following command: https://www.postgresql.org PostgreSQL: Documentation: 10: 22.2. Creating a Database
CREATE DATABASE name ;. where name follows the usual rules for SQL identifiers. The current role automatically becomes the owner of the new database. https://www.postgresql.org PostgreSQL: Documentation: 9.2: Creating a Database
CREATE DATABASE name;. where name follows the usual rules for SQL identifiers. The current role automatically becomes the owner of the new database. https://www.postgresql.org PostgreSQL: Documentation: 8.1: Creating a Database
The first database is always created by the initdb command when the data storage area is initialized. (See Section 16.2.) This database is called postgres. So to create the first "ordinary" ... https://www.postgresql.org PostgreSQL: Documentation: 9.0: CREATE DATABASE
By default, the new database will be created by cloning the standard system database template1. A different template can be specified by writing TEMPLATE ... https://www.postgresql.org |