Using PostgreSQL client applications

One of the most popular and widely used PostgreSQL client applications is pgAdmin III. This application is free to download and use, and there are versions available for several operating systems, including Microsoft Windows, macOS, and Linux.

To download pgAdmin III, visit http://www.pgadmin.org/download. Follow the instructions for your computer's operating system to install the application.

After you have downloaded and installed pgAdmin III, you can use it to manage your PostgreSQL databases. To do this, follow these steps:

1. Start pgAdmin III.

2. On the File menu, click Add Server.

3. On the Properties tab, in the Name text box, type a name for the server connection. The name can be whatever you want.

4. In the Host text box, type pg800x.site4now.net(you can easily find it in control panel)

5. Confirm that the Port text box value is set to 6432 (Note: SmarterASP doesn't use port 5432).

6. In the Maintenance DB text box, type the name of the PostgreSQL database that you want to access.

7. In the Username text box, type the username for the PostgreSQL database.

8. In the Password text box, type the username's password.

9. Click OK. pgAdmin III connects to the server.

10. In the Object browser pane, click the + icon next to the connection name you specified in step 3. The tree expands to show Databases, Tablespaces, Group Roles, and Login Roles.

11. Click Databases, and then click the name of the database you specified in step 6.

• To access the PostgreSQL console for the database, on the Plugins menu, click PSQL Console.

• To run the SQL query tool, on the Tools menu, click Query tool.

To view the online documentation for pgAdmin III, please visit http://www.pgadmin.org/docs.

FYI, if you don't want to use client applications, SmarterASP provide an online tool, please go to control panel->datababases->PostgreSQL->...->Web Manager