At AcuGIS, we want you to get the most out of your hosting experience. While you can always create a support ticket for any assistance you may require, we have added the tutorials below to assist with the most common tasks. Please also view our knowledgebase as well as FAQ, If you have any questions, or have a tutorial you would like to see added, please contact us or raise a support ticket.

 

PostgreSQL Test Scripts (Create, PHP, PDO, JSP, Perl, Python):

• PostgreSQL Test Scripts

 

Basic PostgreSQL Operations using cPanel:

• Create a PostgreSQL Database
• Create a PostgreSQL User

 

Basic PostgreSQL Operations using phpPgAdmin:

• Access PhpPgAdmin
• Create a PostgreSQL Schema
• Create a PostgreSQL Table (with Primary Key)
• Download a PostgreSQL Backup
• Add a colum to an Existing Table

 

Step-by-Step: Auto-Increment on Primary Key using phpPgAdmin:

In this two-part series we will see how to create a Sequence and then use the Sequence we created to auto-increment a primary key column.

• Part 1: Create a Sequence
• Part 2: Auto-Increment

 

Step-by-Step: Create a Trigger to Timstamp Inserts and Updates on a Table using phpPgAdmin:

In this three-part series we will see how to create a trigger that will timestamp inserts and updates on a table.

• Step 1: Add a colum to an Existing Table
• Step 2: Create a Function in phpPgAdmin
• Step 3: Create a Trigger in phpPgAdmin

 

 

AcuGIS PostgreSQL Knowledebase Articles: Below, you will find some of our Knowledgebase articles from our Support portal. We have 100s of articles and new articles are added weekly.

• Move tables between schema
• How Do I Issue Grants for all Tables

 

Have questions? Please contact us.