Madhurig at 06:09, 6 February 2026

2026-02-06T06:09:54Z

Madhurig: Created page with "'''Title of the script''':''' Create Database using PgAdmin.''' '''Author''':''' EduPyramids''' '''Keywords''': RDBMS, PostgreSQL, pgAdmin, Database, table, field, record, E..."

2026-02-06T02:24:01Z

Created page with "'''Title of the script''':''' Create Database using PgAdmin.''' '''Author''':''' EduPyramids''' '''Keywords''': RDBMS, PostgreSQL, pgAdmin, Database, table, field, record, E..."

New page

'''Title of the script''':''' Create Database using PgAdmin.'''

'''Author''':''' EduPyramids'''

'''Keywords''': RDBMS, PostgreSQL, pgAdmin, Database, table, field, record, EduPyramids, video tutorial.

{| border=1
|-
| | '''Visual Cue '''
| | '''Narration '''
|-
|| '''Slide 1'''

'''Title Slide'''
|| Welcome to the Spoken tutorial on '''Creating a Database using pgAdmin 4'''.
|-
|| '''Slide 2'''

'''Learning Objectives '''
|| In this tutorial we will learn to,
* Connect the database to the server and
* Create a database.

|-
|| '''Slide 3'''

'''System Requirements'''
|| To record this tutorial, I am using
* Ubuntu''' 24 point 04 L T S.'''
* Post greS Q L version 18 point 1 and''' '''
* P g Admin 4 version''' 9 point one one '''</span>
* A working internet connection.

|-
|| '''Slide 4'''

'''Pre-requisites '''

[https://edupyramids.org/ https://EduPyramids.org] '''
|| To follow this tutorial, * Learners should have '''Post gres Q L''' and '''p g Admin 4.'''
* For the pre-requisite '''Post gres Q L '''tutorials, please visit this website.

|-
|| '''Screencast:'''
|| Let us open '''p g Admin 4'''.
|-
|| '''Screencast:'''

Go to '''Show Apps '''and search for '''pgAdmin4''', click on the icon.

Cursor on the interface.
|| Go to '''Show Apps''' and search for '''p g Admin 4''', click on the icon.

This is the interface of '''p g Admin 4'''.
|-
|| '''Screencast:'''

Cursor on '''Object'''.

Zoom in (Press '''Ctrl ++''')to see the objects clearly while recording.

'''Screencast:'''

Click on the '''Properties''' tab, and show the cursor on the tab.
|| On the left hand side we can see the '''Object Explorer'''.

Various objects of the database will be displayed here.

In the toolbar, '''Properties''' tab shows the respective properties of each object.
|-
|| '''Screencast:'''

Click on the '''SQL''' tab, and show the cursor on the tab.

Point to the text shown brown colour.
|| Besides '''Properties''', we have a '''S Q L''' tab.

This tab displays the script of the selected object.

As of now no '''S Q L''' query is shown.
|-
||
|| Let us now see how to connect to the '''server'''.
|-
|| '''Screencast:'''

Go to the left panel, right click on '''Servers'''.

Select '''Register''' and then select '''Servers.'''

Cursor on '''Register -Server '''window.
|| In the left panel, right click on '''Servers'''.

A context menu opens. Select '''Register''' and then select '''Server.

Register Server '''window is displayed.

|-
|| '''Screencast:'''

Under '''General,''' in the name tab type '''localhost'''.

Click on the '''Connection''' tab.

In the '''Host name/address''' type: '''localhost'''.
|| Under '''General,''' in the '''Name''' field let’s type '''localhost'''.

Now let us click on the '''Connection''' tab.

Type '''localhost''' in '''Host name slash address'''.
|-
|| Leave the other parameters as default.
|| Let us keep all the other parameters as default.
|-
|| '''Screencast:'''

Point the cursor on the Maintenance '''database''' name and '''Username'''.

Enter password as: '''postgres'''

Click on '''Save''' button.
|| Note that, '''Maintenance''' '''database''' name and '''Username''' fields are prefilled.

Please enter the '''password''' which is given during installation.

Save password toggle is displayed.

Click on the toggle to enable it.

Click on '''Save''' button at the bottom right corner.

Localhost '''Dashboard''' opens.
|-
|| '''Screencast:'''

In the left panel, point the cursor to the '''localhost'''.

Click on the '''localhost''' node drop down arrow.

Point the cursor to the objects.
|| Here, we can see that a connection has been established to the '''localhost'''.

Click on the '''localhost''' node.

We can see the following objects for this particular '''server'''.
|-
|| '''Screencast:'''

Click on the '''Databases''' node drop down arrow.

Point the cursor to the default '''postgres''' database
|| Now click on the '''Databases''' node dropdown.

The default '''database postgres''' created during installation is displayed here.
|-
|| '''Slide 5'''

'''What is Database?'''
|| A '''database''' is an organized collection of data.

A '''database''' contains objects such as tables, views, functions, and procedures.

We can create multiple '''databases''' based on application requirements.
|-
|| '''Screencast:'''

Go back to '''pgAdmin'''.

Right-click on '''Databases''' node select '''Create''', from the sub menu select '''Database'''.

Cursor on '''Create-Databases''' window.
|| Now, we will create a new '''database.

'''Right click on '''Databases''' node.

Select '''Create''', from the sub menu select '''Database'''.

'''Create Database''' window is displayed.
|-
|| '''Screencast:'''

Type database name: '''Studentdb''' and click '''Save'''.

Cursor on the '''Studentdb''' database.
|| Type '''Student d b''' as the '''database''' name and click '''Save '''at the bottom.

Now the newly created database is listed under the '''Databases''' node.
|-
|| '''Screencast: '''

Click on the X button to close the window.

Point to the pop up window.

Point to the message.

Click the blue '''Yes''' button to close the window.
|| Click on the close button to close the window.

A pop up window '''Quit P g Admin 4 '''opens.

It shows a message '''Are you sure you want to quit the application?'''

Click the blue colored '''Yes '''button to close the window.
|-
|| '''Slide 6'''

'''Summary'''

In this tutorial we will learn to,

* Connect the database to the server and
* Create a database.

|| With this we come to the end of this tutorial.

Let us summarize.
|-
|| '''Slide 7 '''

'''Assignment'''

As an Assignment, please do the following:

* Create a Database with the name '''Empdb'''.

|| As an Assignment, please do the following.
|-
|| '''Slide 8'''

'''Thank You'''
|| This Spoken tutorial is brought to you by EduPyramids Educational Services Private Limited, SINE, IIT Bombay.

Thank you for joining.
|-
|}

@@ Line 47: / Line 47: @@
 || Let us open '''p g Admin 4'''.
 |-
 || '''Screencast:'''
@@ Line 79: / Line 71: @@
 || Besides '''Properties''', we have a '''S Q L''' tab.
-This tab displays the script of the selected object.
+The tab displays the script of the selected object.
 As of now no '''S Q L''' query is shown.
@@ Line 96: / Line 88: @@
 || In the left panel, right click on '''Servers'''.
-A context menu opens. Select '''Register''' and then select '''Server.
+A context menu opens.
 Register Server '''window is displayed.

PostgreSQL-Database/C2/Creating-a-Database-using-pgAdmin4/English - Revision history

Madhurig at 06:09, 6 February 2026

Madhurig: Created page with "'''Title of the script''':''' Create Database using PgAdmin.''' '''Author''':''' EduPyramids''' '''Keywords''': RDBMS, PostgreSQL, pgAdmin, Database, table, field, record, E..."