New : Remote data collection with AcuGIS Scout free with all plans
Image US +1 302 384 9810

This page has links to test scripts you can use to test PostgreSQL connectivity for php, pdo, perl, jsp, and python.

In each script you will need to change the database name, user name and password to your own. While you can change any of the scripts to query an existing table, our PostgreSQL Create Script can be used to create all of the objects used in the test scripts.

Simply log into phpPgAdmin, paste the contents of PostgreSQL Create Script into the SQL window, and execute. .

 

PostgreSQL Test Scripts

PostgreSQL Create Script - paste into SQL window in phpPgAdmin and execute. This will create a schema, sequence, table, and insert 3 rows of data into the table.

PostgreSQL PHP Test Script - Save as php-test.php and upload to your public_html directory. Browse to http://yourdomain.com/php-test.php

PostgreSQL PDO Test Script - Save as pdo-test.php and upload to your public_html directory. Browse to http://yourdomain.com/pdo-test.php

PostgreSQL Perl Test Script - save as perl-test.pl and upload to your home directory. Log in via SSH and issue: 'perl perl-test.pl'

PostgreSQL JSP Test Script - save as jsp-test.jsp and upload to your servers document root. Browse to http://domain.com/jsp-test.jsp

PostgreSQL Python Test Script - save as python-test.py and upload to your home directory. Log in via SSH and issue: 'python python-test.py'

 

Have questions? Please contact us.

Clients and Sectors

Serving individuals and institutions in over 70 countries worldwide.
01

International

Image

International

International governmental institutions. Email gov@acugis.com

02

Government

Image

Government

Local, State, and Federal. Email gov@acugis.com

03

Academia

Image

Academia

Discounts for Academic institutions. Email edu@acugis.com

04

NGO

Image

NGO

Non-Governmental Organizations. Email edu@acugis.com

05

Research

Image

Research

Public and Private Research institutions. Email edu@acugis.com

Our Mission

Making your life easier

Our mission is to make your job easier. AcuGIS is a world-leader in making GIS accessible and easy to use. Our focus is on administration and providing you with the best possible hardware, software, network, tools, and support so you can focus on your business with confidence. At AcuGIS, we understand that the success of your application relies on experienced, skilled administration. AcuGIS is owned and operated by Cited, Inc. serving clients in over 70 countries worldwide since 2006. Our support staff combine years of GIS, PostgreSQL, Tomcat, and Linux administration. .

Cited, Inc.
Wilmington, Delaware