How to do it...

The easiest way to create a data table in the PostgreSQL database server is to use pgAdmin 4. Connect to the database server using the user ID that you will use to create the data table. In this case, you will log in using the postgres ID. Once you are connected to the database, perform the following steps:

  1. Expand the Databases lists.
  2. Expand Schemas.
  3. Expand public.
  4. Right-click on Tables. Then, select Create and click on Table….

Now, you have the Create - Table dialogue box opened as shown in the following screenshot:

  1. In this box, the first step is to give the data table name as airlineDB. After giving the name, the next step is to define each of the columns as per their properties, as shown in the following screenshot:

Here, ROW_ID is a unique serial number for each row. It will be used as a primary key for this database.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset