Modern R Programming Cookbook

How it works…

The data table is now ready under the postgres database. The steps described in the previous section are quite intuitive. After opening the Create - Table dialogue box, the obvious step is to give the table name. After that, explicitly define each of the columns with their properties. In this case, there were four integer variables, two character variables, and two numeric variables. Since each data table should have one primary key to uniquely identify each row, the ROW_ID column has been added to serve this purpose.