What Is phpPgAdmin and What Is It Used For?

Home » Knowledge Base » Hosting Basics » What Is phpPgAdmin and What Is It Used For?

phpPgAdmin‘s relation to PostgreSQL is the same as the one formed between phpMyAdmin and MySQL. More specifically, phpPgAdmin is a web-based software utility that allows you to manage your PostgreSQL database. The tool can be opened in a web browser as a regular page and it will work in the same manner regardless of the operating system that you are using.

As its name implies, phpPgAdmin is written using PHP and features easy-to-use tools for administering a PostgreSQL database. If you have used phpMyAdmin in the past, then phpPgAdmin’s interface will feel familiar to you since the tool’s look and feel were inspired by phpMyAdmin in the first place.

Through phpPgAdmin, you are able to view your stored information in tabular form, create new records, edit existing ones, and delete those that you no longer need. In addition to that, you have advanced sorting and filtering features at your disposal. That said, perhaps the biggest strength of phpPgAdmin is its support for the Structured Query Language (SQL).

Thanks to its full SQL support, phpPgAdmin can be used to execute SQL queries. These queries can perform bulk edits on the stored information. They can also be used to add new information to the database. And perhaps the most versatile and widely used feature is the ability to create complex queries that are able to retrieve only the information that you are interested in.

phpPgAdmin is available on all hosting plans that support PostgreSQL as a database option. More specifically, this includes most of our paid hosting plans, our Virtual Private Server instances, and our semi-dedicated servers.

Was this post helpful?

i

Relevant tags:

Connect

Latest posts:

How to Customize Menus in SuiteCRM

SuiteCRM grants you the option to customise your website menus and control what modules appear in them, how they are grouped and in what categories. This customisation can help you improve user workflow and reduce clutter, especially if you are working on a large...

How to Add Charts to the Sidebar in SuiteCRM

Àlthough SuiteCRM doesn't support adding charts directly to the sidebar, there is a simple method that you can use to achieve the effect. In this guide, we share how to do so.   How to Add Charts to the Sidebar in SuiteCRM The process is comprised of a few...

How to Add Subpanel Filters in SuiteCRM

SuiteCRM's subpanels can be very useful in various situations, such as showing related records (like contacts under an account). However, as your database grows, so does the scrolling time through unfiltered subpanels. Fortunately, you can add filters to subpanels, so...

How to Display Fields in Different Modes in SuiteCRM

SuiteCRM allows for various customisations of fields. Such are the Detail View, Edit View and List View. Understanding how to customise these is important for tailoring your SuiteCRM project to your preferences. Whether you are streaming data entries or are trying to...

How to Add Grouped Fields to the Record View in SuiteCRM

SuiteCRM offers great versatility when it comes to customising modules, including how fields are displayed on record views. One powerful feature is grouping fields within sections for better layout and user experience. In this article, we share how to group fields in...



Create a website for free!


Free forever

Our Support Team is Here to Help

 

If you need any questions answered, don't hesitate and contact us. Click the button below and follow the instructions. You can expect an answer within an hour.

 

Contact AwardSpace

 

iNewest knowledge base articles

How to Customize Menus in SuiteCRM

SuiteCRM grants you the option to customise your website menus and control what modules appear in them, how they are grouped and in what categories. This customisation can help you improve user workflow and reduce clutter, especially if you are working on a large...

How to Add Charts to the Sidebar in SuiteCRM

Àlthough SuiteCRM doesn't support adding charts directly to the sidebar, there is a simple method that you can use to achieve the effect. In this guide, we share how to do so.   How to Add Charts to the Sidebar in SuiteCRM The process is comprised of a few...

How to Add Subpanel Filters in SuiteCRM

SuiteCRM's subpanels can be very useful in various situations, such as showing related records (like contacts under an account). However, as your database grows, so does the scrolling time through unfiltered subpanels. Fortunately, you can add filters to subpanels, so...

How to Display Fields in Different Modes in SuiteCRM

SuiteCRM allows for various customisations of fields. Such are the Detail View, Edit View and List View. Understanding how to customise these is important for tailoring your SuiteCRM project to your preferences. Whether you are streaming data entries or are trying to...

How to Add Grouped Fields to the Record View in SuiteCRM

SuiteCRM offers great versatility when it comes to customising modules, including how fields are displayed on record views. One powerful feature is grouping fields within sections for better layout and user experience. In this article, we share how to group fields in...

How to Back Up Your SuiteCRM Project

Making regular backups of your SuiteCRM project is crucial. Backups help keep any kind of data safe, and also provide a quick recovery after a crash, hacking attack, or any user error. Because of how important backups are for your SuiteCRM website, in this article, we...

Even more web tutorials

Check out our web hosting knowledge base and the WordPress tutorials to learn more, and be better prepared for your website creation and maintenance journey.