Get solutions and answers to your PostgreSQL development questions here.
This article covers how to use the psql program to connect directly to PostgreSQL from the command line, as well as some commonly-used psql commands.
Learn how to use two methods for connecting to a PostgreSQL database using PHP: PostgreSQL native functions, and PDO (PHP Data Objects). This article includes code samples to get you up and running.
There are several ways you can connect to a PostgreSQL database using Python. This article includes sample code that shows how to use the psycopg2 and PyGreSQL packages to access PostgreSQL databases.
Learn how to connect to a PostgreSQL database using Perl's DBI module. This article includes code samples to get you up and running.
Learn how to import and export a PostgreSQL database. If you already have a database that you want to install on an A2 Hosting server, or you want to back up your database, this article shows you several methods for exporting (using the pg_dump program or phpPgAdmin,) importing (using the psql program or phpPgAdmin,) and how to create a new PostsgreSQL database so that databases can be imported.
There are two options for connecting to PostgreSQL databases remotely. This article covers how to use an SSH tunnel or a direct connection.
You can use PostgreSQL client applications to manage your PostgreSQL databases remotely. These client applications can be faster and easier to use than cPanel or the command line. This article covers how to use the popular pgAdmin III application.
Learn how to set up a cron job that automatically backs up a PostgreSQL database at defined intervals.
Learn how to do common PostgreSQL administration tasks from the command line. This article covers how to create and delete PostgreSQL databases and users. Please note that this article only applies to unmanaged products.
Learn how to determine which versions of PostgreSQL and PostGIS are installed on a server using the psql command-line program.
This article demonstrates how to determine the size of PostgreSQL databases and tables by using the phpPgAdmin web interface or the command line.
There are scenarios such as data migration or site development where you may want to rename a PostgreSQL database. Learn how to rename a database from cPanel and the command line in this article.
ECCN and HTS numbers are used for export control from the United States to another country. Learn more about these numbers and PostgreSQL in this article.