How to create table in postgresssql

Steps in pgAdmin to Add Columns

1. Open the Table In pgAdmin, expand your database by clicking on it. Navigate to Schemas > Tables. Find and select your table (e.g., entity_highlight).
2. Open the Table Properties Right-click on the table name. Select Properties from the context menu.
3. Add Columns Go to the Columns tab. Click the + (Add) button to add a new column.
4. Define Columns For each column, specify the following details:

Column 1: id

Name: id
Data Type: SERIAL
Primary Key: Check the box or configure it in the Constraints tab.
Click Save or OK.
Column 2: text

Name: text
Data Type: TEXT
NOT NULL: Check the box to enforce this constraint.
Column 3: org

Name: org
Data Type: JSON
NOT NULL: Check the box to enforce this constraint.

1. Save Changes Click Save or OK to apply the changes.