Gyan Sangrah

Create a table in database using pg admin in postgresql

In this article, we will create a table in database using pg admin.

Steps

To add a table

1. Expand the ‘Schemas’ tab inside the database.

2. Inside it, right-click on the ‘Tables’ icon and click on Create → Tables

3. A window will appear to enter table name, owner, schema etc.

4. Once the table name is added, click on the ‘Columns’ tab to add column.

5. Here, you can click on ‘+’ sign to add columns. Once you click on ‘+’, a row is added.

Enter the name, data type (you can fill other details as well) and click on ‘Save’ button.

A new table is created.

Query/Feedback