How to create a new table in pgAdmin 4

Answered 1 year ago (Jun 15, 2023) by Eldernode Staff

To create a new table in pgAdmin 4, you can follow these steps:

Log in to pgAdmin 4 and from the object tree on the left side, expand the database where you want to create the table.

Right-click on the “Tables” node and select “Create” > “Table…” from the context menu.

In the “General” tab of the “Create Table” dialog, provide a name for your table in the “Table Name” field.

In the “Columns” tab, click on the “+” button to add a new column and provide the column name, select the data type, and specify any additional properties. Repeat this step for each column you want to add.

In the “Constraints” tab, you can define the primary key, unique, and foreign key, and check constraints for the table if needed.

In the “Advanced” tab, you can specify additional options such as storage parameters, table owner, and description.

After configuring the table’s properties, click the “Save” button to create the table.