How to Create a Database in Postgresql

What is a Postgresql DAMS?

Postgresql is a DBMS ( Database Management System ). It is open-source software, PostgreSQL uses SQL language backend and provide a lot of functionalities like SQL and more. Postgresql store data safely and scale the complicated data workloads. Postgresql, support almost all operating systems like Linux, Windows and MAC.

How to Create Database in Postgresql on different Operating Systems?

We can use PostgreSQL on all operating systems. The generic syntax for creating a database in PostgreSQL.

CREATE DATABASE databasename ;

Example to create a database in Posgresql

CREATE DATABASE name

                               [              [ WITH ] [ OWNER [ = ] user_name ]

                                               [ TEMPLATE [ = ] template ]

                                               [ ENCODING [ = ] encoding ]

                                               [ LC_COLLATE [ = ] lc_collate ]

                                               [ LC_CTYPE [ = ] lc_ctype ]

                                               [ TABLESPACE [ = ] tablespace ]

                                               [ CONNECTION LIMIT [ = ] connlimit ]

 ]

Explanation of Parameters

Name:

The Database name that you are creating.

user_name:

Write the user name who will use this database and define his role.

Template:

Write the template name which you want to use in this database, otherwise, the default template will automatically set. The default template is template1.

Encoding:

Set the encoding style of your database, for example, SQL_ASCII. ASCII stands for American Standard Code for Information Interchange. 

lc_collate

LC_COLLATE means collection order in your new database. This will effects on your data in sorting order, you can set your data collection through LC_COLLATE. Otherwise, default ORDER BY will set depend on your template.

lc_ctype

LC_TYPE means character classification of your new database. It affects your character categorization, for example, lower case, upper case. Default LC_TYPE depends on your template.

Tablespace

Tablespace defines an alternative location for the data on the file system in database objects.

Connlimit

Connlimit means you are defining connections for this database, how many users can connect with your database. The default value means no limit.

How to Create Database in Postgresql in Linux

In Linux first, you want to register user and then you can access the PostgreSQL terminal. Then you can create a database in PostgreSQL.

How to create a PostgreSQL database in Linux using the command line is given below:

• First, you access the root permission it required your system password
• Su – postgres
• Now you can write a simple query for creating a PostgreSQL database.
• createdb -0 user dbname

Almost all Linux flavours support it and you can easily create a database using the terminal.

How to create a database in PostgreSQL in CentOS 7

After the installing ContOS 7 on your pc. You can create a database in using these simple steps:            

• createdb testDB
• createuser samplerole –pwprompt
• createdb testDB -O samplerole
• psql testDB

How to Create Database in Postgresql Using pgAdmin

A simple procedure for creating a database using pgAdmin is:

• Click on pgAdmin and Open it.
• Build a connection with the database.
• Follow this ( Edit => New Object=> New Database )
• Click on done

How do I create a new database in PostgreSQL?

How do I create a database in PostgreSQL pgAdmin?

Is Postgres database free?

How do you set up a database?

Does Google have a database application?

How can I get a free database?

Is there a free database?

What will replace Microsoft Access?

What are the top 5 databases?

Which database is used by Google?

Is Google considered a database?

Which database is best and why?

What is an example of an online database?

Why are databases better than Google?