• Your Cart is Empty
  • Cart
  • Log In

How to create a PgSQL table

How to create a PostgreSQL database table using phpPgAdmin - overview

1. First you need to log into your web hosting Control Panel. Click the 'Control Panel' login link in the upper right corner of the page to go to the Members Area Login form. Then input your account's username and password in the corresponding fields and click the 'Login' button to go straight to your Control Panel.

2. In the Control Panel you need to click on the PostgreSQL Databases icon to open the PostgreSQL Databases section.

3. Once in the PostgreSQL Databases interface - go to the table listing your databases and open the phpPgAdmin tool by clicking on your database name or on the 'phpPgAdmin' icon.

Now you are in phpPgAdmin - the PostgreSQL Database management tool.

3.1. Here you need to select the name of your database first.

To do this simply click on 'Tables' to explore the table list of your selected PostgreSQL database. No tables will be listed if you haven't created any so far.

3.2. Now click on the 'Create Table' link and fill in the name of the new table in the 'Name' field. Then set the number of the table columns and click the 'Next' button.

3.3. Set the title name of the first column, for instance NAME, if you are creating a phone book list, and select the column type from the drop-down menu. You can also specify the length of the column and some additional attributes, if necessary. Then repeat the steps specifying the attributes of the second and the third column and click on the 'Create' button to create your new PgSQL table.

You already know how to create a PostgreSQL database table in 3 easy steps.