This section examines about how to make another data set in your PostgreSQL. PostgreSQL gives two different ways of making another information base −
- Utilizing CREATE DATABASE, a SQL order.
- Utilizing createdb an order line executable.
Using CREATE DATABASE
This order will make an information base from PostgreSQL shell brief, however you ought to have proper advantage to make a data set. Of course, the new data set will be made by cloning the standard framework information base template1.
The fundamental language structure of CREATE DATABASE explanation is as per the following −
CREATE DATABASE dbname;
where dbname is the name of an information base to make.
Coming up next is a basic model, which will make testdb in your PostgreSQL blueprint
postgres=# CREATE DATABASE testdb; postgres-#
Using createdb Command
PostgreSQL order line executable createdb is a covering around the SQL order CREATE DATABASE. The lone distinction between this order and SQL order CREATE DATABASE is that the previous can be straightforwardly run from the order line and it permits a remark to be added into the information base, across the board order.
The punctuation for createdb is as demonstrated beneath −
createdb [option...] [dbname [description]]
The table given underneath records the boundaries with their portrayals.
|S. No.||Parameter & Description|
The name of a database to create.
Specifies a comment to be associated with the newly created database.
command-line arguments, which createdb accepts.
The accompanying table records the order line contentions createdb acknowledges −
|S. No.||Option & Description|
Specifies the default tablespace for the database.
Echo the commands that createdb generates and sends to the server.
Specifies the character encoding scheme to be used in this database.
Specifies the locale to be used in this database.
Specifies the template database from which to build this database.
Show help about createdb command line arguments, and exit.
Specifies the host name of the machine on which the server is running.
Specifies the TCP port or the local Unix domain socket file extension on which the server is listening for connections.
User name to connect as.
Never issue a password prompt.
Force createdb to prompt for a password before connecting to a database.
Open the order immediate and go to the catalog where PostgreSQL is introduced. Go to the container catalog and execute the accompanying order to make an information base.
createdb -h localhost -p 5432 -U postgres testdb password *****
The above provided order will provoke you for secret phrase of the PostgreSQL administrator client, which is postgres, naturally. Consequently, give a secret phrase and continue to make your new information base
When a data set is made utilizing both of the previously mentioned techniques, you can check it in the rundown of information bases utilizing \l, i.e., oblique punctuation line el order as follows −
postgres-# \l List of databases Name | Owner | Encoding | Collate | Ctype | Access privileges -----------+----------+----------+---------+-------+----------------------- postgres | postgres | UTF8 | C | C | template0 | postgres | UTF8 | C | C | =c/postgres + | | | | | postgres=CTc/postgres template1 | postgres | UTF8 | C | C | =c/postgres + | | | | | postgres=CTc/postgres testdb | postgres | UTF8 | C | C | (4 rows) postgres-#