What is PostgreSQL?

PostgreSQL is a web hosting database that is used to store web site information like blog posts or user information. PostgreSQL is a very popular relational database used on the web. This is partly because it completely free but it also has some features that other databases, like, MySQL, don't have.

PostgreSQL Features

In basic terms, PostgreSQL is capable of storing any type of data of that you want. You can easily store and retrieve information using SQL statements. It also, importantly, allows multiple web site visitors to use it at once. In more technical terms, PostgreSQL has the following features:

What is PostgreSQL Logo
  • Functions
  • Indices
  • Triggers
  • MVCC
  • Rules
  • Wide variety of data types including unlimited length text, IPv4 and IPv6 addresses, arrays, and XML
  • User-defined object
  • Inheritance
  • Sub-selects
  • Transactions
  • Full, inner, and outer joins
  • Views
  • Referential integrity
  • Tablespaces
  • Regular expressions

PostgreSQL is used by several different web programming languages including PHP, and Python. These programming languages make is extremely easy to connect to a PostgreSQL database. It is also used for many content management scripts.

phpPgAdmin

Databases can be difficult to manage using just individual SQL statements. It is much easier to manage a database using a graphical user interface (GUI). One of the best and most popular GUI’s for managing a PostgreSQL database is called phpPgAdmin. It is a web-based application that makes it easy to manage your PostgreSQL database. phpPgAdmin will let you add, remove and manage databases, tables, and entries; backup the database, run specific SQL queries, search and import record, and much more. Learn more about phpPgAdmin from its official website.

What is phpPgAdmin?

Learn more about PostgreSQL on its official website. They have comprehensive documentation and other support information You should also check out the SQL tutorial on W3Schools and O'Reilly’s Practical PostreSQL book.

If you are looking for a web host that supports PostgreSQL, look at our comparison of PostgreSQL Web Hosting or try our web hosting wizard which will give you more search options.

© Host Shopper | Web Host Comparisons | All Rights Reserved