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):
Basic PostgreSQL Operations using cPanel:
Basic PostgreSQL Operations using 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.
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.
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.
- Connect to Database via PSQL (SSH)
- Set Schema Search Path
- How Do I Issue Grants for all Tables
- Change User or Database within PSQL Session
- Get Database Disk Size using PSQL
- Get Table Size using PSQL
Have questions? Please contact us.
An Enciva LLC Company
3635 S. Fort Apache Road
Las Vegas, Nevada 89147
Tel: 702 922 7130