Modern R Programming Cookbook

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:

5. In this box, the first step is to give the data table name as airlineDB. After giving the name, the next ...