SQL
stands for Structured Query Language. SQL is an international standard
in querying and retrieving information from databases. PostgreSQL
is, like MySQL, essentially an SQL server and database - it responds
to requests for information that are written in SQL. You can communicate
with PostgreSQL using a wide variety of programming languages, including
PHP, Perl, and Python. PostgreSQL is Open Source software and generally
free for commercial or personal use.
The
following links provide good introductory information about PostgreSQL
:
To
add a PostgreSQL database:
-
Click
on the PostgreSQL databases button on the home
page.
-
Enter
the name of the database in the Db field.
-
Click
on the Add Db button. The database will be
added to the /var/lib/mysql folder.
You need to create at least one database user and grant that
user permission to use the new database. Refer to Creating
a PostgreSQL user and Grant
a user's permissions to a PostgreSQL database for more information.
Topics:
Removing
a database
Creating a PostgreSQL user
Grant a user's
permissions to a PostgreSQL database
Managing PostgreSQL databases
|